Forum Discussion

thompsza's avatar
thompsza
Frequent Visitor
4 years ago
Solved

multiple Y axis line chart, slice by y-axis fields

PBI Newbie here.   Ok, so I've spent a few days tyring to track down a solution for this and I just haven't been able to come up with anything that makes any sense, please help!   The data I'm wo...
Need Help
  • jsaunders_zero9's avatar
    jsaunders_zero9
    4 years ago

    Have a look into using a disconnected slicer and a switch statement to show the selected measures.

    As an example you could create your 7 measures and then an 8th "SelectedMeasure" 

    Doing this will mean only one measure is added to the visual but the value of said measure will align to what the user has selected.

    Happy to set it up if you can provide some sample data.

    Thank you

jsaunders_zero9's avatar
jsaunders_zero9
Responsive Resident
4 years ago

Have a look into using a disconnected slicer and a switch statement to show the selected measures.

As an example you could create your 7 measures and then an 8th "SelectedMeasure" 

Doing this will mean only one measure is added to the visual but the value of said measure will align to what the user has selected.

Happy to set it up if you can provide some sample data.

Thank you