Forum Discussion
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 create a mesure to do that.
I have tried following this post:
But it returns all values as blank. I am trying to select something from the table "Work Order Details" and have it filter the two card visuals below.
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.
4 Replies
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?
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.
Did anyone figure this out? I am having the same issue
