Filter Card Visual Based on Table Visual Selection

[WiggityZwiggity]

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.

[Jhanson93]

Did anyone figure this out? I am having the same issue

[v-xicai · Accepted solution]

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.

[amitchandak]

@WiggityZwiggity , try isfiltered

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[WiggityZwiggity]

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?