Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
1 year ago
Solved

Different Number Format based in selection

Hey experts!

I have a matrix visual with 20 different measures.

These measures gets aggregated per country.

Now I would like to get the Format "thousands" for all country, but if only "Spain" is selection, I would like to get the numbers for Spain as a whole number as it is.

What would be the best / most lean approach to get this done?

Dynamic formatting?

  • joshua1990 Hi! Yes, the best approach to achieve this in Power BI would involve dynamic formatting using DAX measures and a conditional formatting setup. 

    If you need help to create the measures, please provide some sample data and the actual measures.

     

    BBF

1 Reply

  • BeaBF's avatar
    BeaBF
    Super User

    joshua1990 Hi! Yes, the best approach to achieve this in Power BI would involve dynamic formatting using DAX measures and a conditional formatting setup. 

    If you need help to create the measures, please provide some sample data and the actual measures.

     

    BBF