Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How To assign labels to slicer values?

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!

Need Help
  • CoreyP's avatar
    CoreyP
    6 years ago

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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

  • nhoward's avatar
    nhoward
    Icon for Resolver I rankResolver I
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        CoreyP
        Icon for Solution Sage rankSolution Sage
        6 years ago

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