Filter include all data column yes/no

[Anonymous]

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!

[Anonymous · Accepted solution]

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

[bfernandez]

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?

[Anonymous · Accepted solution]

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

[bfernandez · Accepted 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 😁

[Anonymous]

Thanks, I've explore this solution in the past, for me it's not the best as is weird whe you have several visual cards on the page, but seen that no other solution can be use......
Let's wait for another idea and in case nothing else it's posted I'll mark your solution as solved.
Thanks for your time... aprecciate it.

[Anonymous]

Not solved yet sorry

[Anonymous]

Thanks, I've explore this solution in the past, for me it's not the best as is weird whe you have several visual cards on the page, but seen that no other solution can be use......
Let's wait for another idea and in case nothing else it's posted I'll mark your solution as solved.
Thanks for your time... aprecciate it.