Forum Discussion
different naming conventions in slicer
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.
tried removing spaces and it's still not happy:
4 Replies
- Greg_Deckler
Community Champion
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.
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"
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.
tried removing spaces and it's still not happy:
