Change text on slicer buttons

[Anonymous]

Background: I have a Slicer with the following headings “Select All”, “0” and “1”.

Issue 1: The end user doesn’t know what “0” and “1” stand for.

Issue 2: The list view of the slicer takes up too much space.

1st Attempt

I created a nice toggle switch, it takes up little space, and the end user can understand when the search criteria is off or on (0 or 1).

Issue; Using a toggle switch (via bookmarks), resets current data that is being searched. You can use multiple slicers in sync with each other, but bookmarks reset slicers to the condition when the bookmark was saved.

2nd Attempt

I thought that maybe I will have to scrap the toggle switches and go back to slicers, but I need to change the 0’s and 1’s to “Off” and “On”. You can’t just right click on the slicer and change the name so I thought maybe I should try and make a measure.

Does anybody have a good idea how I can simply change the text on the slicers?

Thank you

[Dan1_102]

Late answer but probably good for others. I had the same issue with an int column (0,1) wanting to edit the tiles as text.

Therefore you click the "Transform Data" Button on the Home register on Power BI,

Step 1:

select the whole column and right click, choose Change Type --> Text

Step 2:

Right click again and choose replace Values...

Then type in the Value To Find, and the Value to replace with.

(f.e. 0 = done, 1= open)

[Anonymous]

Hi @Anonymous,

Instead of 0 and 1 what you want to show?

Could you please share your sample file.

Best Regards,

Ravi

[Anonymous]

Actually not only Off or On you can change whatever you want.

[Anonymous]

How would I changed it to "On" or "Off", sorry there's probably a simple fix that I haven't thought about.

[Anonymous]

1.You have to create a column like

If ([Column]=0,"Off","On") and in slicer drag that new column.

2. There is a option in power bi "enter data". using that just manipulate what you want in slicer and put the data like that and join that table with main table.

It will helpful if you could share your sample data or file. i can show you.

[Anonymous]

That works 🙂 but one worry I have is that my main data source is coming in from a server. If I edit that table and add a new column, do you think it will cause a problem next time the data is loaded?

[Anonymous]

Thats a good question .

If data is always 0 or 1 then there will be no problem. But if data is changes anything apart from 0 and then you have to change Column condition.

Regards,

Ravi