How To assign labels to slicer values?

[Anonymous]

Hi All,

How does one assign values to a slicer where the values read are like 1 or 0 but I want a label such as yes or no for example.

Thanks!

[nhoward]

HI @Anonymous 

Have you tried changing the data type in Power Query Editor?  If the whole column is 0 and 1, then changing the type to True/False puts the words into your data. 

I don't know of a way to assign a label to a value of a slicer, the data itself has to say what you want to display. 

regards,

Neville

[Anonymous]

Thanks but I have another control where I number values that I need to change to text so this solution will not work.

Many Thanks1

[CoreyP · Accepted solution]

You could do the dimension table as stated above, or add a custom column, if [field] = 1, "yes" , "no"

[Anonymous]

What's your use case? Can you give an example?

You can create a new table with the "Enter Data" button of the home tab and key in the values you want for the slicer and use that table as a dimension that you can use as a slicer after you've created the appropriate relationships.

[Anonymous]