Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
Did anyone figure this out? I am having the same issue
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.
@WiggityZwiggity , try isfiltered
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
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?
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |