Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
How to create a filter or checkbox for the Column header in Power Bi
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)
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
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.
Can you please show the expected vs reality of what you are getting?
Thanks,
Arul
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:
It is not feasible. But would be helpful if you explain it bit more in detail to understand the problem.
Thanks,
Arul
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |