Forum Discussion
aruntd77
10 years agoHelper I
Table Visualization and Report Filter Exclusion
Hi, I have a situation, hope someone can give me valuable guidance to achieve what I want. I have built a report which has Years as Filter. All the KPIs I have in that report should use Yea...
- 10 years ago
aruntd77 You can use slicer for Years as well instead filter. Then in power bi desktop select Years slicer and click Visual Tools -> Edit Interactions then select None for all visuals for which you don't want to apply that slicer (in your case table visual). Similarly do for Product Type slicer as required.
ankitpatira
10 years agoCommunity Champion
aruntd77 You can use slicer for Years as well instead filter. Then in power bi desktop select Years slicer and click Visual Tools -> Edit Interactions then select None for all visuals for which you don't want to apply that slicer (in your case table visual). Similarly do for Product Type slicer as required.
- aruntd7710 years agoHelper I
Thank you!
I liked your Idea to keeping Years as Slicer.
I will get back once I complete the testing.