Replace text in a chiclet Slicer

[sajarac]

Hi there.

I hope someone could point me in the right direction.

In my Share point date I have a column where the values are i.e:

Production_Unit_A

Production_Unit_B

Production_Unit_C

Once I have added my chiclet slicer I have the same text. Is possible to use the subsititute funtion here?

I would like to see in my slicer "Production Unit A"

Or in every visual where I have to use that column without the "_"

thanks in advance for any help

[sajarac]

Thank you very much. I got it now.

🙂

[aj1973]

Hi @sajarac 

You can rename the fields either in Power Query or in the desktop.

[sajarac]

Hi, thank you very much for your prompt response.

I didtn't explain correclty. What I meant is to change the values inside the visual like this:

[aj1973 · Accepted solution]

No Problem,

Well, If you have acces to Power Query then you can add a Conditional Column where you can change the names of the cells accordingly.

If not then you can add the calculated column in your model using DAX (IF or SWITCH).

Do you know how?