Forum Discussion
Slicer using excel column headers
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.
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. :smileyhappy:
Regards
1 Reply
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. :smileyhappy:
Regards