Forum Discussion
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 ...
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.
How do you define the returned column in DAX? IF(ISFILTERED(Stores[StoreName]),[Units Sold],BLANK()) i.e. where [Units Sold] is the column name?
