Dynamic Graph

[bubblepop]

Is it possible to create a graph whose y values change based on what a user selects in a checkbox? For example, having one graph that can display the number of people over time or the customer retention rate over time, etc. Basically keeping the x-axis, time, consistent, but allowing a user to change what is plotted on the y-axis. Perhaps with Power BI bookmarks but not sure what implementation would look like. Thanks.

[V-pazhen-msft]

@bubblepop 
You need to create a isolate table as the slicer, and then create measures for each measures you want to display on Y aixs using IF(contains()). You may follow the tutorials step by step.

Dynamically select measures to be shown on a Power BI visual via slicer | Excel Inside (excel-inside...

Dynamic Selection of Measures in Power BI (kpipartners.com)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Pragati11 · Accepted solution]

Hi @bubblepop ,

See there is an existing thread for this:

https://community.powerbi.com/t5/Desktop/Dynamically-change-Y-axis-based-on-input-from-drop-down-or-...

Thanks,

Pragati