Forum Discussion
Card not showing correct count when using table visual filters
BeAStar okay, I figured out what is going on! Completely a rookie error on my part. The color filtering you are doing in the Filter pane is at the Visual level, not at the page level.
Below is using the Countrows with a Slicer:
Below is the Countrows however filtering Color on the table visual:
Ultimately, when you have the slicers in there, and you are filtering, it won't be an issue. If you want to use the Filter pane options, then just add colour to the page filter level like below:
Hope this helps!
Theo 🙂
BeAStar no problem. As long as you understand that by adding the filter at the Visual level, you are restricting the filter to that Visual. If you want to have other visuals on the page filtered based on a filter selection, then just move filter from the Visual to the Page level. This gives you what I gather you are after (e.g. no slicers and the KPI card to give the number of row in the table).
All the best with it!
Theo
Thanks TheoC I have way too many visual filters for user to select and adding them to the page would take the whole page, was hoping to get the count without having to use slicers. Thanks again for the options!!
BeAStar no problem. As long as you understand that by adding the filter at the Visual level, you are restricting the filter to that Visual. If you want to have other visuals on the page filtered based on a filter selection, then just move filter from the Visual to the Page level. This gives you what I gather you are after (e.g. no slicers and the KPI card to give the number of row in the table).
All the best with it!
Theo