topic Re: Change Data Type for Column Chart with changing filter in DAX Commands and Tips

Change Data Type for Column Chart with changing filter

Anonymous — Tue, 29 Oct 2024 13:52:02 GMT

Hello,

I am trying to visualize multiple KPIs on the same column chart and you can navigate through the different KPIs by choosing the desired KPI from a slicer. However, the KPIs aren't all the same unit (some are percentages, some are currency, and some are absolute values), the column chart y-axis unit doesn't change with choosing the KPI, instead it remains the same for the first data I place in the "column y-axis" tab. I want them to change with the change of selection from slicer.

To clarify, as seen in first two pictures, I placed MC Efficiency (%) in the first slot above GGA(grams) and the tables are showing percentages because the data type of MC Efficiency is set to percentage. In picture 3&4 When I switch the positions of the MC Efficiency and GGA, placing the GGA above, all the values change to absolute and no percentages are shown.

How do I overcome this

Re: Change Data Type for Column Chart with changing filter

SamWiseOwl — Tue, 29 Oct 2024 14:45:25 GMT

Hi Anonymous

Have you considered using a Field Parameter:

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

You can then set the created measure to have a Dynamic Format:

https://www.wiseowl.co.uk/blog/s3218/dynamic-formating-measure.htm

Re: Change Data Type for Column Chart with changing filter

Anonymous — Wed, 30 Oct 2024 06:53:51 GMT

Hi Anonymous ,

Thanks SamWiseOwl for the quick reply. I have some thoughts to add:

(1) This is my test data.

(2) We can create measures to have Dynamic Format:

_value = ABS(SUM('Table'[value])) //absolute value measure

(3) We can create a field Parameter.

(4) Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.

Re: Change Data Type for Column Chart with changing filter

Anonymous — Sat, 09 Nov 2024 18:08:25 GMT

Wow Thanks so much Anonymous for your detailed and informative solution!!
I appreciate your help a lot! 🤗