Forum Discussion

rpjheeney's avatar
rpjheeney
Frequent Visitor
1 year ago
Solved

Card Visual

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
Need Help
  • saud968's avatar
    saud968
    1 year ago

    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!

saud968's avatar
saud968
Memorable Member
1 year ago

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's avatar
    rpjheeney
    Frequent Visitor
    1 year ago

    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's avatar
      saud968
      Memorable Member
      1 year ago

      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!