Switch Measures values in chart

[msaninfo]

I calculcated measures for 2017, 2018, 2019 for some business units. see sample table below. Using this table, i need to create a stacked column chart.  (Axis should be year 2017, 2018, 2019) and stacked bar should be BU..  The challenge here is my year values are calculated from measures which can't drag under legend. so how to solve this case?

Looking forward to hear back..

Many thanks,

Sankar 

[v-jingzhang]

Hi @msaninfo , measures cannot be set as legend or axis. To approach the stacked column chart you expect, it seems Axis should be years, Legend should be BU and Values should be the measure.

Best Regards,

Community Support Team _ Jing Zhang

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

[msaninfo · Accepted solution]

Thank for your comments. I got a solution from the below link..

https://radacad.com/dax-measure-in-the-axis-of-the-power-bi-report