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!

3 Replies

  • 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!