Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Set font style within SWITCH measure

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

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

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

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

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

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    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