How to rename values in slicer?

[Anonymous]

Dear All,

I am seeking for help for the following:

I have the following slicer, by making use of field 'Geannuleerd Door Klant':

It shows 0,00 and 1,00 

Instead of these valuies I would like to show "NO" and 'YES" --> 0,00 is "NO" and 1,00 is "YES"

I am think to build a separate measure for this. Can someone help me out here?

Thanks!

[mh2587 · Accepted solution]

Column = IF([Column] = 1,00,"Yes","No")
//Create new column for that and try it
//And then put the new created column in slicer

[ribisht17 · Accepted solution]

@Anonymous 

>>> Cal_Col >>> if(Geannuleerd Door Klant=1,"Yes","No")

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[themistoklis · Accepted solution]

@Anonymous 

Have you tried creating a new column with an IF statement?

e.g.

New Column = IF (TableName[Geannuleerd Door Klant]= 0, "NO", "YES")

[Anonymous · Accepted solution]

When option of adding a column is blocked, would it also be possible to do it by creating a measure?

[themistoklis · Accepted solution]

why is it blocked.. how do you connect with the source... through direct query?

[Anonymous · Accepted solution]

When option of adding a column is blocked, would it also be possible to do it by creating a measure?

[themistoklis · Accepted solution]

why is it blocked.. how do you connect with the source... through direct query?

[Anonymous · Accepted solution]

It's hidden. I imported the Power BI data set. Probably protected by the company

[themistoklis · Accepted solution]

@Anonymous 

Have you tried creating a new column with an IF statement?

e.g.

New Column = IF (TableName[Geannuleerd Door Klant]= 0, "NO", "YES")

[ribisht17 · Accepted solution]

@Anonymous 

>>> Cal_Col >>> if(Geannuleerd Door Klant=1,"Yes","No")

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[mh2587 · Accepted solution]

Column = IF([Column] = 1,00,"Yes","No")
//Create new column for that and try it
//And then put the new created column in slicer