Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
HariKrishBI01
Regular Visitor

Column header has filter

How to create a filter or checkbox for the Column header in Power Bi

6 REPLIES 6
HariKrishBI01
Regular Visitor

HariKrishBI01_0-1678791688816.png

HariKrishBI01_1-1678791819927.png

 

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)

@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.

Arul_0-1678812445874.png

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

Arul_1-1678812522826.png

Thanks,

Arul

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


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.

HariKrishBI01_0-1678814284861.png

 

@HariKrishBI01 ,

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

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


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

HariKrishBI01_0-1678815012186.png

 

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:

HariKrishBI01_1-1678815075766.png

 

HariKrishBI01_3-1678815276346.png

 

Arul
Super User
Super User

@HariKrishBI01 ,

It is not feasible. But would be helpful if you explain it bit more in detail to understand the problem.

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.