Forum Discussion
How to show specific value
I would appericate it if someone can help me. How do I create a DAX formula to only show specific value. For example, I would like to create a Dax formula to only show branch 19, 22, 27 and ex...
VahidDM
Super User
Super UserHi noble10
Try to add a column with this code to your table:
IF you want to have Branch No. in your slicer:
Filtered Branch = if('Table'[Branch] in{19,22,21},'Table'[Branch])
If you want to have a Location Name in your slicer:
Filtered Branch = if('Table'[Branch] in{19,22,21},'Table'[Location Name])
Then add Filtered Branch column to your slicer.
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
