Slicer using excel column headers

[Chrishurcombe]

I have a line chart with multiple daily market price date (X axis), for example, daily crude oil price and GBP/EUR tracking against the date (Y axis). 

As the chart contains a lot of data it looks crowded, and I am looking for a way to use the headers as the slicers,  For example, select crude oil and compare this to another measure over a given time frame. 

Date slicers are working fine, but how can I use a slicer to choose what data I only want to view.

Data is updated daily and is built in an excel table.

Was hoping a new table containing the column headers would be a simple fix, but not worked.

[v-ljerr-msft · Accepted solution]

Hi @Chrishurcombe,

If I understand you correctly, you can use Unpivot Columns option in Query Editor(which turns multiple column headers into a single column but in rows. and store their values in another column) to unpivot your crude oil price and GBP/EUR column first, then you can use the Attribute(Header Name) column as Legend , Value column as Value on the Line Chart, and then use Attribute(Header Name) column as a Slicer to choose what data you want to view. For more details about how to Unpivot Columns in Power BI Desktop, you can refer to this article.

Regards