Different Number Format based in selection

[joshua1990]

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?

[BeaBF · Accepted solution]

@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