Card Visual

[rpjheeney]

Hi

Is there a way for the card display to be blank, rather than the first record in the table showing, when a slicer is set to All?

Thanks

Rob

[saud968]

Yes, you can achieve this by using a measure to control the display of the card. Here’s a step-by-step approach:

Create a Measure: Create a measure that returns a blank value when all items are selected in the slicer.

DisplayValue =
IF(
ISFILTERED('Table'[Column]),
FIRSTNONBLANK('Table'[Column], BLANK()),
BLANK()
)
Use the Measure in the Card: Replace the existing field in the card visual with this new measure.

This way, when the slicer is set to "All," the card will display a blank value instead of the first record in the table.

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!

[rpjheeney]

Hi Saud, many thanks for this. 

This has worked when the slicer is set to All. However, when I select a new value from the slicer, the value in the card still displays (Blank) instead of the value I've selected from the dropdown.

Is there a way round this? 

Thanks

Rob

[saud968 · Accepted solution]

Let's modify the measure to ensure it displays the selected value when a specific item is chosen from the slicer:

DisplayValue =
IF(
ISFILTERED('Table'[Column]),
FIRSTNONBLANK('Table'[Column], BLANK()),
BLANK()
)
To ensure the card updates correctly when a new value is selected, you can use the HASONEVALUE function to check if only one value is selected:

DisplayValue =
IF(
HASONEVALUE('Table'[Column]),
VALUES('Table'[Column]),
BLANK()
)
This measure will display the selected value when one item is chosen from the slicer and show a blank value when the slicer is set to "All."

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!