Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is there a way to allow report viewers to toggle the visibility of Y-Axis data on a stacked column chart?
This visualization has multiple Y-Axis values, and the users have asked to be able to show one or more of the fields when they view the report.
Thanks
Solved! Go to Solution.
Hi @opyke ,
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2)We can create three measues.
sum of value1 = SUM('Table'[value1])
sum of value2 = SUM('Table'[value2])
sum of value3 = SUM('Table'[value3])
(3) We can create a field parameter.
(4) Then the result is as follows.
Please refer to the following documents for more information.
Field Parameters in Power BI - Microsoft Power BI Community
Dynamic X and Y Axis in Power BI visuals? Yes please! - YouTube
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @opyke ,
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2)We can create three measues.
sum of value1 = SUM('Table'[value1])
sum of value2 = SUM('Table'[value2])
sum of value3 = SUM('Table'[value3])
(3) We can create a field parameter.
(4) Then the result is as follows.
Please refer to the following documents for more information.
Field Parameters in Power BI - Microsoft Power BI Community
Dynamic X and Y Axis in Power BI visuals? Yes please! - YouTube
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |