Forum Discussion
pfarahani
Helper II
Helper IISlicer with Data Only
Hello All, I need some help so that the slicer I have for departments only display's Department have actually exist in my core fact tables. This is my slicer for department that contains about ...
HI pfarahani,
I'd like to suggest you write a measure expression as a filter to check the current category and correspond value. You can write if statement to replace not exists part as blank and use it on the visual level filter to exclude not matched records.
Applying a measure filter in Power BI - SQLBI
If you are confused about the coding formula, please share some more detailed information to help us clarify your scenario.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng