Forum Discussion

NKotak_Leecare's avatar
NKotak_Leecare
Icon for Helper III rankHelper III
3 years ago
Solved

Display in matrix based on selection from a filter

Hi all,

 

I have created three measures following this: Show or Hide a Power BI Visual Based on Selection - Excelerator BI for displaying a message when nothing is selected from the filter and the visual remains empty. However, the filter that I have has values that are there in the visual as well. For example, the name by which I am filtering the visual is also present in the matrix visual itself. So, when I am adding the Hide Visual measure to the visual, it is ignoring it and displays all the name values even when nothing is selected from the filter. 

 

Measure 1: 

Check Filter = ISFILTERED(person[FullName]) -- Returns TRUE when any selection is made
 
Measure 2:
Hide Resident Visual BR =
IF(
    [Check Filter],
    1,
    0
)
 
Measure 3:
Message =
IF (
    [Check Filter],
    -- Check Filtered returns true or false based on selection in slicer
    "",
    --Give me nothing when Check Filtered returns True
    "You must first select a Resident from Resident Filter to see the results."
)
 
The filter and visual snapshots:
 
 

Do we have any solution for that?

 

Thank you!

1 Reply