Forum Discussion

Trescher's avatar
Trescher
Frequent Visitor
8 months ago

Conditional formatting of measures

Hi,   I have multiple measures in my report and I want to make the font color change based on the value of the measure.    Let's say i have two measure; measure A and measure B, which are both pe...
Need Help
Trescher's avatar
Trescher
Frequent Visitor
8 months ago

Thanks Krishnakanth, i tried this but somehow my matrix only results into white values which indicates that this formula results in blank/null values. 

 

See screenshots below. The icons work perfectly as expected but the coloring font does not. 

 

Do you have any idea why?

 

Thx

 

 

 

 

krishnakanth240's avatar
krishnakanth240
Icon for Super User rankSuper User
8 months ago

Hi Trescher 

 

Thanks for confirming!

 

For the color change to black, Go to 'Format Visual' after selecting the visual

Navigate to 'Specific column'

Choose 'measure' from Series (In Apply settings to)

Navigate to 'Values'

Change the 'Text color'

 

Please give headsup it is working fine and accept it as a solution to help other community members. Thank You!

 

  • Trescher's avatar
    Trescher
    Frequent Visitor
    8 months ago

    Hi,

     

    Whats the point of this if i need to change the text back to black again? The icons work, but the function you provided does not. 

    The problem is that the function doesnt evaluate per cell with SELECTEDMEASURE() to return a value for the coloring.