Forum Discussion
multiple Y axis line chart, slice by y-axis fields
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
I have setup a basic file for you to show what I mean.
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
I have setup a basic file for you to show what I mean.
Thats exactly what i needed, thank you so much!
I ended up creating a series of bookmarks with action enabled buttons for the report i'm working on, but I know that I'll have the same thing going on in a couple other dashboards they want me to build so I'll definitely be using this. I should be able to use the sample you created to build the visuals in the future, the sample data you provided is basically what I'm dealing with.
Again, thank you very much! I really appreciate the help!
