Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Switch Measures values in chart

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 

Need Help

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi Anonymous , 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.