Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi there
I have a transparent card with a message working perfectly, to hide a visual if a filter has NOT been applied. The message says "you must first select a filter to view results"
This is only working on one slicer, and I have two. One is Dim_Name and the other is Dim_Plan
Here are my two measures:
Check Filtered = IF(ISFILTERED(Dim_Name[Name]),1,BLANK())
Transparent = IF(NOT(ISBLANK([Check Filtered])),"#FFFFFF00")
So with the above, measure if Dim_Plan is filtered, the card remains in place with the message because there is no reference to Dim_Plan in the 'Check Filtered' measure. I tried the following but it doesn't work:
Check Filtered = IF(ISFILTERED(Dim_Name[Name]),1,BLANK())||IF(ISFILTERED(Dim_Plan[Plan]),1,BLANK())
Can I ask Power BI to check two filters?
Solved! Go to Solution.
Try:
Transparent = IF(OR(ISFILTERED(Dim_Name[Name]), ISFILTERED(Dim_Plan[Plan])),"#FFFFFF00")
Proud to be a Super User!
Paul on Linkedin.
Try:
Transparent = IF(OR(ISFILTERED(Dim_Name[Name]), ISFILTERED(Dim_Plan[Plan])),"#FFFFFF00")
Proud to be a Super User!
Paul on Linkedin.
Works and I no longer need the filter check measure 😄
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |