Table, Card and Fitering so the card unit count updates with whats in the table

[akhaliq7]

I have a table that shows all the data in my fact table, I have a card that shows a unit count total, I have a filtering tab that when a filter is applied to a field then it needs to both filter the table and the card. I could use filters on the page level but the visual level gives a more accurate count of values in the table. Is there a workaround so I can use visual level filtering and my card also filters.

[v-yingjl · Accepted solution]

Hi @akhaliq7 ,

As card visual analyzes only one value and this value is always aggregated, we cannot add filter conditions based on this aggregated value.

When the specified field under the visual level filter panel contains more than one value, we can set the filter conditions through advanced filtering, such as highlighting with color.

For more information，you can refer to this ：

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-report-filter

^{Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}