Forum Discussion
OmoigirlBI
2 years agoFrequent Visitor
Filters with descriptions instead of codes
Good morning, I have a question, I want to make a filter by description instead of codes, that is, I have a table of countries where there are country codes and their corresponding name are matched, ...
- Anonymous2 years ago
Hi OmoigirlBI
You can create a measure.
Measure = VAR a = SUMMARIZE ( FILTER ( MASTER - GEOGRAPHY, [GEOGRAPHY_CODE] IN VALUES ( 'MY REPORT'[GEOGRAPHY_CODE] ) ), [GEOGRAPHY_DESCRIPTION_ES] ) RETURN IF ( SELECTEDVALUE ( MASTER - GEOGRAPHY[GEOGRAPHY_DESCRIPTION_ES] ) IN a, 1, 0 )Then put the measure to the slicer visual filter and remove your code field
Then it can only display the description.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
OmoigirlBI
2 years agoFrequent Visitor
Yessss!!! It´s working!!!
Thank you very much