Forum Discussion

HariKrishBI01's avatar
HariKrishBI01
Regular Visitor
3 years ago

Column header has filter

How to create a filter or checkbox for the Column header in Power Bi
Need Help
Arul's avatar
Arul
Super User
3 years ago

HariKrishBI01 ,

Go to power query editor and select all the month columns then do unpivot columns.

Now you will get a output like the below and then rename the columns as you want.

Now close and apply, then in Power BI desktop use the month column in slicer,

Thanks,

Arul

 

 

HariKrishBI01's avatar
HariKrishBI01
Regular Visitor
3 years ago

Thanks Its working but, one small doubt here when iam selecting  all the checkboxes  iam getting the sum of all the percentage instead i need to get them individually.

 

  • Arul's avatar
    Arul
    Super User
    3 years ago

    HariKrishBI01 ,

    Can you please show the expected vs reality of what you are getting?

    Thanks,

    Arul

    • HariKrishBI01's avatar
      HariKrishBI01
      Regular Visitor
      3 years ago

      Reality : Here Iam getting sum of percentage of all the months

       

      Expected, When i select all it should come like this but if i click the check box for individual month only that column should come. as attached below: