Forum Discussion

WiggityZwiggity's avatar
WiggityZwiggity
New Member
6 years ago
Solved

Filter Card Visual Based on Table Visual Selection

I am trying to filter a card visual so that it does not show first/last/count values in the visual until something is selected from a table visual (not a slicer) and cannot seem to figure out how to ...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi WiggityZwiggity ,

     

    The returned column is the field that you hope to be displayed in your two cards.

     

    You may create measure to determine if show the message or a field value in original card, and display the measure in Card visual hover your original  Card visual.

     

    Selector= IF(HASONEVALUE(Table1[Name]),FIRSTNONBLANK(<Field that needs to display in original card visual>, 1),"No selection is chosen")

     

    You may refer to the similar case: https://community.powerbi.com/t5/Desktop/Stacked-Column-chart/m-p/648754#M311066.

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi WiggityZwiggity ,

 

The returned column is the field that you hope to be displayed in your two cards.

 

You may create measure to determine if show the message or a field value in original card, and display the measure in Card visual hover your original  Card visual.

 

Selector= IF(HASONEVALUE(Table1[Name]),FIRSTNONBLANK(<Field that needs to display in original card visual>, 1),"No selection is chosen")

 

You may refer to the similar case: https://community.powerbi.com/t5/Desktop/Stacked-Column-chart/m-p/648754#M311066.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.