Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 😁
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |