Dynamically change the Y-axis units based on a Measure/Slicer Selection

[Anonymous]

Hi all,

Is there a way to change the units & title of an axis? 

For example when I have Quantity show the value and when I have Sales show sales and $ sign on the values. Some context, I have two cateories bikes and cars and I have created a measure that switches the values. On a table this works fine but not on a bar chart.

Any help?

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

May I ask if your problem has been solved? Is the above post helpful to you?
As far as I know, the calculation group should be able to help you.
Here is an introduction to calculation groups.
https://apexinsights.net/blog/10-uses-for-calculation-groups

You can also see my idea about switching axes in the following thread.
https://community.powerbi.com/t5/Desktop/help-with-dax-calculation-on-which-date-column-to-use/m-p/2136599#M788875

Best Regards,
Community Support Team _ Zeon Zheng

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

[amitchandak]

@Anonymous , for that you might have to use the calculation group. There you can have format for each measure

https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions#limitations