Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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
Icon for Super User rankSuper User
3 years ago

Anonymous ,

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

 

 

Anonymous's avatar
Anonymous
Not applicable
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
    Icon for Super User rankSuper User
    3 years ago

    Anonymous ,

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

    Thanks,

    Arul

    • Anonymous's avatar
      Anonymous
      Not applicable
      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: