different naming conventions in slicer

[wotkara]

Good morning, I'm hoping you can help.

In our rental software which includes employees, our locations are named:

• C
• MC
• O
• OKC

In Bamboo, they are named:

• Loving
• Kiowa
• Odessa
• OKC

Locations will not change but employees and equipment are added daily.

How can I slice the page by location when my location names don't match? Right now, I have 2 slicers but thats not user friendly. 

Appreciate any help please. Thank you.

[wotkara · Accepted solution]

tried removing spaces and it's still not happy: 

[Greg_Deckler]

@wotkara Not sure I have all the information needed for a full solution but seems like you could always just add a conditional/calculated column that converts the names. In DAX, a simple SWITCH statement would suffice.

[wotkara]

Thank you Greg for your reply. I have looked further into your reply and found this helpful solution:

Solved: Is there a way to use SWITCH with CONTAINS? - Microsoft Fabric Community

However, I am receiving an error message when trying to duplicate it. Will you explain the error to me so I can fix? Thank you.

[wotkara]

Yes both sound great but I'm new to this world so do you mind telling me how to do this?

I have 13 tables that use office location "C" "MC" "O" "OKC"

I have 1 table aka Employee that uses "Loving" "Kiowa" "Odessa" "OKC"