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 "Sucursal", I have a different value for the reference lines (in x-axis and y-axis), and It's not a calculated value, the values are pre-defined numbers (but different for each Sucursal), I just want to plot them on the chart when I filter it.

 

Is there a way to "move" the reference line when I select a different "Sucursal"?

 

Obs: the reference line is kind a "goal", dots "after" the line means they are good. But as said before, goals are different depending on the Sucursal selected.

 

 

Thanks!

 
Need Help
Tutorial Requests

4 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    You could find  Quadrant Chart custom visual in Power BI.

    The default Scatter chart doesn't support to add such feature. If the custom visual doesn't meet your requirement completely, you could vote the similar idea here.

     

    • PbiGlobal's avatar
      PbiGlobal
      Frequent Visitor
      6 years ago

      Quadrant chart doesn't have that functionality.Any other option?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    For Cabo Frio for example: I have x-axis (7) and y-axis (2,6).      [7; 2,6]

    But for Araruama, it is I have x-axis (5) and y-axis (3).                [5; 3]

  • 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