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
HariKrishBI01's avatar
HariKrishBI01
Regular Visitor
3 years ago

 

Thanks Arul ,

is it possible ?

I want checkbox as highlighted ,to check as per month . My requirement is to add a checkbox or any filter for months(Column)

  • 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