Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic Reference Line in Scatter Chart by Filter

Hello,   I have this dashboard below, and I would like the "reference line" in the scatter chart to be dynamical. For exemple, I have a filter on the screen called "Sucursal", and for each "Sucursa...
Need Help
Tutorial Requests
mahenkj2's avatar
mahenkj2
Solution Sage
4 years ago

Hi Anonymous ,

PbiGlobal,

v-eachen-msft,

 

Although an old post, but since it has no accepted solution and I see the possible solution is available as standard feature in Power BI Desktop, I tested it and it is working fine.

 

Now we can add dynamic reference lines for X and Y axis (as well as many other type of lines).

 

 

In the analytics pane, you can see above options. Select a reference table column value to use as a dynamic number for user to change values.

 

I also attach a sample file.

 

https://drive.google.com/file/d/18Vqo648GcsorF066vrw7yAQe9MIYjnvX/view?usp=sharing