2 visual cues in one dimension within pivot table

[francisvandergr]

I have a dashboard with the values O and the Value L. For those values i have 2 visual cues:

see attached example:

='AVG O in relation to total orders ' & count({1<Status = {O}>}[offerte Nr.]) / Count( {1} Total [offerte Nr.] ) & ' 

if AVG from Status O  in table > then formula above,  Green else Red'

='AVG L in relation to total orders ' & count({1<Status = {L}>}[offerte Nr.]) / Count( {1} Total [offerte Nr.] ) & ' 

if AVG from Status L  in table < then formula above,  Green else Red'

[sunny_talwar]

Sorry but I don't know what you question is? Is something not working as expected?

[francisvandergr]

If avg of status O is above 39,8% i wanna have green below  this value it must be red 

If avg of status L is below 26,55% i wanna have green above this value it must be red

39,8 comes  from : count   ({1<Status = {O}>}[offerte Nr.]) / Count( {1} Total [offerte Nr.] )

26,55 comes from : count({1<Status = {L}>}[offerte Nr.]) / Count( {1} Total [offerte Nr.] )

[sunny_talwar · Accepted solution]

Is this what you are looking for?

Instead of using visual cues, try using Text Color:

[francisvandergr]

Yes! indeed do you have for me the QVW so i can see what you have done in the text colour formula ?

[sunny_talwar]

It is attached with my post above.

[francisvandergr]

Hi sunindia,

Sorry but i downloaded the file and the formula is gone. You have the formula for me ?

Gr

Francis

[sunny_talwar]

Expression I used is:

If(Status = 'O', If(AVG < Count(TOTAL {1<Status = {'O'}>}[offerte Nr.])/Count( {1} Total [offerte Nr.]), RGB(0,127,0), RGB(255,0,0)),

If(Status = 'L', IF(AVG < Count(TOTAL {1<Status = {'L'}>}[offerte Nr.])/Count( {1} Total [offerte Nr.]), RGB(0,127,0), RGB(255,0,0))))

HTH

Best,

Sunny