Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, need some help with deffault filtering. I have table, and what i want is to filter a specific variable from each column and then use it to display the result in a "card". the users will be able to use the slicer to filter through the data, and if they hit the reset button, it will again default back to the filtered results.
the table looks like this:
What i want is to measure the No. of Participants by displaying the default value when
State="ALL", District="ALL", DisabilityGroup="ALL", AgeRange="ALL", SuppClass="ALL"
This will be default card value. The users will have the option to use the slicer and disect the results by whatever way they want.
Is it possible? How can i do it?
I am new to PowerBI and would love a detailed explanation on how to solve this.
Thanks.
Asif
i was hoping to get a solution using Dax. is there? or is bookmark the only option i got?
Hi @AsifAnwar ,
By my test, can't achieve it by DAX, as the selected value in slicer does not change unless reselected.
I'm afraid you can only get it by bookmark.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@AsifAnwar , You can create a bookmark with all that can allow you reset it will. All other slicer show work as usual
https://radacad.com/clear-all-slicers-in-power-bi-a-bookmark-story
Your clear position is all selected in slicers
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
25 | |
20 | |
14 | |
8 |
User | Count |
---|---|
71 | |
48 | |
46 | |
20 | |
16 |