Forum Discussion

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 v...

Need Help

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