Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I am using the following code to show the drill down path of a visual, (i.e. Make, Model, Year)
The customer wants the card to show "No Filter Selected" when nothing is selected. I am using a card and it displays (Blank)
DRILL_PATH =
SELECTEDVALUE ( Table1[Make] )
& IF (
NOT ( ISBLANK ( SELECTEDVALUE ( Table2[Model] ) ) ),
" --> " & SELECTEDVALUE ( Table2[Model] )
)
& IF (
NOT ( ISBLANK ( SELECTEDVALUE ( Table3[Year] ) ) ),
" --> " & SELECTEDVALUE ( Table3[Year] )
)
How do I get the card to display the custome text, then follow the steps in the code?
Solved! Go to Solution.
@Anonymous , isfiltered can help
refer my video for more details https://www.youtube.com/watch?v=hXg3kRFSGjA
A new measure like
if(no(isfiltered ( Table1[Make])),"No Filter Selected" ,[Drill path])
Thank you, that worked perfectly!
@Anonymous , isfiltered can help
refer my video for more details https://www.youtube.com/watch?v=hXg3kRFSGjA
A new measure like
if(no(isfiltered ( Table1[Make])),"No Filter Selected" ,[Drill path])
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
11 | |
9 | |
8 | |
8 |