Forum Discussion
Filter include all data column yes/no
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!
- Thanks but I tryed and this is not the answer I'm.looking for, probably bad question made by me sorry
Your solution will present two buttons, one "no"another "yes". With both selected I'll have the desired result.
I want two buttons, one "all" that summarize yes and no posibilityes in the column, and another for example "yes" that sumarrize only rows with "yes" option.
Thanks by the way 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 😁
6 Replies
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?
- Thanks but I tryed and this is not the answer I'm.looking for, probably bad question made by me sorry
Your solution will present two buttons, one "no"another "yes". With both selected I'll have the desired result.
I want two buttons, one "all" that summarize yes and no posibilityes in the column, and another for example "yes" that sumarrize only rows with "yes" option.
Thanks by the wayThen 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 😁