Dynamic: Unit - axis

[Anonymous]

Hi everyone!

I'm working on a dynamic  "line and clustered column chart" when I switch the measures, all numbers chage (as it's supposed to be). Nevertheless, units don't change.

I've attached two pictures about the process... I wish someone could help me, I'm really stuck!

UNITS: First measure [€] Second measure [€] --> Result OK

When € are selected

UNITS: First measure [%] Second measure [€] --> ERROR.

When % is selected

Thanks in advanced

[amitchandak · Accepted solution]

@PowerPowerBI_20, there is guyinacube video, but you are using external tools to work with different data formats.

See if that can help

https://www.youtube.com/watch?v=vlnx7QUVYME

[Anonymous]

Thanks!

You give me the clue to find the solution, I also found another web where a complete example can be found: https://rollingaverage.com/set-up-measure-selection-with-dynamic-formatting-in-powerbi/