Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |