Forum Discussion

Vanessa250919's avatar
Vanessa250919
Helper V
5 years ago
Solved

Visual card All mention

Hello, I have one question about the CARD visualisation, I need to show the agent name, but when I don't used a filter I see the First Agent Name, it's possible to add the mention "All" in the CARD visualistion ? 

 

thanks !! 

Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Vanessa250919 ,

     

    I am taking following sample data where I have a field named Location as a slicer and a card visual with this value:

    When I select anything in the slicer that value is displayed in the card visual.

    If I understand your requirement correctly, you want to display ALL in the card visual when nothing is selected in the slicer.

    for that create the following measure:

    Measure =
    var t1 = SELECTEDVALUE('Table'[Location])
    RETURN
    IF(t1 = BLANK(), "ALL", t1)
     
    Move this measure to card visual. Now if you don't select anything in the slicer, card visual shows ALL as below:

    Make sure to use your column name in the above measure.

     

    Let me know if this is what you were looking for.

     

    Thanks,

    Pragati

     

2 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi Vanessa250919 ,

     

    I am taking following sample data where I have a field named Location as a slicer and a card visual with this value:

    When I select anything in the slicer that value is displayed in the card visual.

    If I understand your requirement correctly, you want to display ALL in the card visual when nothing is selected in the slicer.

    for that create the following measure:

    Measure =
    var t1 = SELECTEDVALUE('Table'[Location])
    RETURN
    IF(t1 = BLANK(), "ALL", t1)
     
    Move this measure to card visual. Now if you don't select anything in the slicer, card visual shows ALL as below:

    Make sure to use your column name in the above measure.

     

    Let me know if this is what you were looking for.

     

    Thanks,

    Pragati