Different Number Format based in selection

joshua1990 — Fri, 13 Dec 2024 08:48:12 GMT

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?

Re: Different Number Format based in selection

BeaBF — Fri, 13 Dec 2024 08:52:18 GMT

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

topic Re: Different Number Format based in selection in DAX Commands and Tips

Different Number Format based in selection

Re: Different Number Format based in selection