Add value to column filter

[FZOU]

Hello,

I have this filter column which contain two values ("YES","NO"), i want to add another value inside this column Named ("All Answers") which group (YES and NO) but i didn't find a solution,any ideas ? you find below an example.

Thank you 🙂

[Fowmy]

@FZOU 

If you are using this column on a slicer, it already has an ALL option you can turn it on here:

If your table was created using the Enter data Option in Power BI, Right-click on the table > Edit and insert the value for ALL.

IF this was from another source, add it in the source or inform the data source owner to add it for you.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[FZOU]

@Fowmy 

Thank you, i tried to turn on the ALL option on the filter but it shown "Select All" it work great but i want it to be shown as "All Answers" not "Select All" and i can't rename it !

Yes the column from another source i'm looking how can i add it "All Answers"

[Fowmy · Accepted solution]

@FZOU 

Unfortunately, you cannot rename that option, you can request it as a feature to be added to Power BI here: https://ideas.powerbi.com/ideas/

Meantime: have it added to the source.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[amitchandak]

@FZOU , if slicer you have an option for ALL.

But you want what you are showing. Then create an independent table (You can use enter data) with these 3 rows.

And create slicer. Then use the value of this table filter or not filter the data in a measure

[FZOU]

@amitchandak  thank you very much for your response, sorry but i didn't get your point,can you please explain more ?