Toggle visibility of Y-Axis data on a Stacked Column Chart

[opyke]

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

[Anonymous · Accepted 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.