Fields on page should be blank when filtervalue is (Blank)

[Anonymous]

Hi

I have a page with a filter on a field called 'Projects'.

When 'Projects' is (Blank), I would like to have all fields on the page to be (Blank)/Empty/Null..... meaning, showing no result.

Any help on that would be appreciated

Best regards,

Hasse

[v-eachen-msft]

Hi @Anonymous ,

You need to create a new measure to determine if it is selected.

Measure1 =
CALCULATE (
    IF ( ISFILTERED ( 'Table'[Projects] ), 1, 0 ),
    ALLSELECTED ( 'Table' )
)

Then get your result.

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Eads

Thank you for your reply - much appreciated.

I'm not sure where to insert the measure?

E.g. - I have a matrix on the page - tried to apply the new measure as filter on the 'matrix' visual. But I cannot change the value in 'Show items when the value' to "is not".

Best regards,

Hasse

[v-eachen-msft]

Hi @Anonymous ,

Just insert this measure to the visual's filter. You don't need to insert it to the visual.

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Eads

Done it - it does not work. Cannot change to "is not"

Best regards,

Hasse