Set font style within SWITCH measure

[Anonymous]

I have a SWITCH measure (mock up below) which determines which measure to apply based on a value.  I would like to add FORMAT into the SWITCH measure so that if Mapping[Type] is not Blank - if it is any value KPI1 thru KPI8 - then it is formatted Bold.

Switch =

SWITCH (

     TRUE (),

     MAX ( Mapping[Type] ) = BLANK(), [CurrentMonth_Measure],

     MAX ( Mapping[Type] ) = "KPI1", [KPI1_Measure],

     MAX ( Mapping[Type] ) = "KPI2", [KPI2_Measure],

     MAX ( Mapping[Type] ) = "KPI3", [KPI3_Measure],

     MAX ( Mapping[Type] ) = "KPI4", [KPI4_Measure],

     MAX ( Mapping[Type] ) = "KPI5", [KPI5_Measure],

     MAX ( Mapping[Type] ) = "KPI6", [KPI6_Measure],

     MAX ( Mapping[Type] ) = "KPI7", [KPI7_Measure],

     MAX ( Mapping[Type] ) = "KPI8", [KPI8_Measure]

)

Any ideas how to do this?

Thanks,

Stacey

[v-piga-msft]

Hi @Anonymous,

It seems that Format function does not support bold font in Power BI currently.

You could vote this similar idea in Power BI ideas Forum.

You could have a try with the suggestion from @Greg_Deckler.

Best Regards,

Cherry

[Greg_Deckler · Accepted solution]

Not aware of a way to do that, but you could potentially change the color of it using Conditional Formatting.

[Anonymous]

Yes, I was able to change the color, but cannot set it to bold.  Thank you for the suggestion.