Conditional Formating both £ Values and % Values

[Anonymous]

Hi Experts 

I have managed to format the £ values numbers in my matrix table as Red but I am unable to do the same for % values.

Link.

https://www.dropbox.com/s/h611uzqxduhgv3e/sample.pbix?dl=0 

When replying to question kindly outline steps do not post a pbix file. Thanks

[MFelix · Accepted solution]

Hi @Anonymous ,

This is due to the fact that when you are making the change of the % to a FORMAT syntax you are picking up text and not a value so the condittional formatting will not assume the number formatting.

What you need to do is to create a measure exactly like the Slicer_CM but for formatting.

Slicer_CM_Formatting = 
VAR Mth1 =
    SELECTEDVALUE ( SelMth_Current[Month] )
VAR Mth2 =
    SELECTEDVALUE ( SelMth_Prior[Month] )
VAR Fcst1 =
    SELECTEDVALUE ( SelMth4[Actual] )
VAR Fcst2 =
    SELECTEDVALUE ( SelMth3[Actual] )

VAR Opt = 0

VAR MthVal =
    
        CALCULATE (
                SUM ( Profitability_Consolidation[Profit]);
                Profitability_Consolidation[Period] = Fcst1;Profitability_Consolidation[Month] = Mth1
            )
VAR MTDValue =
    SWITCH ( TRUE();
        AVERAGE ( Profitability_Consolidation[Chkfmt] ) =        1 && MthVal <0 ;"Red";
                [Slicer_CM] <0; "Red"
    )         
 RETURN
    MTDValue

Now just use this measure has your formatting value, the "RED" can be change by any colour you want if you use a HEX colourings similar to this "#000000".

[Anonymous]

Hi MFelix...how do i format the values not % to 1dp. Currently 2dp.

[MFelix]

Hi @Anonymous ,

Sorry I'm not understanding the question. What is the 1 / 2 dp?

[Anonymous]

Many thanks MFleix much appreciated for excellent feedback. Ps can you remove the sample pbix file from question i have down loaded it now.

[MFelix]

Done.

[Anonymous]

Many thanks sir.