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

[thompsza]

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 working with is 7 columns of whole numbers that i've created measures for to supply the median of the column. What i'm being asked to produce is a line chart that can provide the median times by month and have a comparison line for the previous year or more etc. With only one measure that has been an easy visual, but they want all 7 in one single chart where they can slice based on which kpi they want to view; e. g. have measures A-G loaded into it, but when they select C, it only displays the information for C and the rest is sliced out. I've tried looking through the 'add visuals' page and tried a few but none seemed to do what I need to accomplish.

So really I have two questions:

1) is there a visual for a line chart that can accept more than one Y-axis value?

2) how do i create a slicer to slice based on a measure, and/or how can i create one that will slice out the 6 other measures?

The only solution i can think of (i may not explain this correctly) but is to create a series of bookmarks and add action buttons/icons to the page that will bring up the wanted information when published. 

Thank you in advance for any help/suggestions!

[jsaunders_zero9 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

I have setup a basic file for you to show what I mean.

thompsza_sample.pbix

[thompsza]

@jsaunders_zero9 

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!