Data field in line chart chose by user

[Anonymous]

Hello,

I am trying to create a slicer or any other way to let users to choose data field to be applied to the line chart.

For example I want to investigate variations over time for various attributes. Instead of creating multiple line charts for every attribute  (which will make my report very crowded) I would prefer to have one line chart and add a slicer/selection (anything) which will let users to choose which column attribute they want to see/investigate in the line chart.

I thought that bookmarks could be a solution, however in previous reports I had issues with bookmarks. They did not update automatically when new data were coming in and I had to go through each bookmark and choose update manually.

Any suggestions??

Thanks! 

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my test, you could refer to below steps in query editor:

1.Sample data.

2.Unpivot columns(except the [Item] column) and the query editor will save every operations to adapt to the updated data.

3.Now you could use the slicer to choose the different field.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/lui9tbf3gjwx60d/Data%20field%20in%20line%20chart%20chose%20by%20user.pbix?dl=0

Regards,

Daniel He

[Anonymous]

Many thanks Daniel,

This looks to work perfectly!

Regards,

MariosChr90