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, maybe it´s a answered question, but I haven´t found the solution to this case,
I´ve this sample data:
values | local customers |
145 | yes |
134 | no |
123123 | yes |
1231 | yes |
545 | no |
4352 | yes |
42525 | no |
And I want to make a filter with buttons like:
Customers | |
ALL | JUST LOCAL |
When you press the "all" button, it has to include all values, in case you press "just local", only shows "yes" values of local costumers.
Wich will be the best aproacho to deal this with out using any DAX calculation?
I´m using a dataset in Direct Query mode.
Thanks in advance fro your time!
Solved! Go to Solution.
Then in this case, you can create bookmarks with buttons to interact with said bookmarks.
Check out this link to better understand bookmarks.
So on one page with all the values selected on the filter create one bookmark called "All".
Then on the same page, simply filter only the "yes"" values and create another bookmark called "Yes".
Now you can insert a button with the Action being set to the Bookmark:
You can then change the button text to show the appropriate values you'd like!
If this solves you issue, please set this post as the solution to better assist other users 😁
In this case you can simply try adding a slicer for the local customers column.
Then in the Format tab, be sure the Show "Select all" option is toggled to the On position.
Does this solve your issue?
Then in this case, you can create bookmarks with buttons to interact with said bookmarks.
Check out this link to better understand bookmarks.
So on one page with all the values selected on the filter create one bookmark called "All".
Then on the same page, simply filter only the "yes"" values and create another bookmark called "Yes".
Now you can insert a button with the Action being set to the Bookmark:
You can then change the button text to show the appropriate values you'd like!
If this solves you issue, please set this post as the solution to better assist other users 😁
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 |
---|---|
100 | |
100 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |