Forum Discussion

Chrishurcombe's avatar
Chrishurcombe
Regular Visitor
9 years ago
Solved

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 look...
Need Help
Show and Tell
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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