Forum Discussion

DR_74's avatar
DR_74
Copper Contributor
Mar 10, 2024

Filter or slicer in a pivot chart

Hi, 

I am trying to add a filter for the different type of baseline so I can show and hide as needed in the chart. the problem is that the BL are in the column header and if I add the filter or the slicer I will have different filter and with the numbers to be filtered.

What I am looking to do is a filter with the list of BL-R00, BLR01 and filter which one I want to see in the chart, but I don't know if is possible and how to make it.

 

 

 

 

thanks 

D

Charting
excel
Formulas and Functions
  • SanthoshKunder's avatar
    SanthoshKunder
    Iron Contributor
    Apr 23, 2024

    DR_74 -You need to unpivot your data (You can use Power Query for this). With this, you will have new columns that look like below.

     

     

Resources