Forum Discussion
Need help in making card static
I'm working on a report where values in the cards should be static when product filters are using and dynamic when non-product filters are used. I was able to bring in this with the help of interacti...
amitchandak
Super User
Super UserCharinite , best way for "All" filter to work with all, it to have them in a separate table. So if you have a product group in a separate table, you can add all(ProductGroup[ProductGroup])
Also, refer if interactions can help
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Thank you for the suggestion. I'll try making another table and see if that helps. I'm trying to limit the number of tables in the model due to the data size.
I was using interactions earlier when we had slicers. Later slicers were removed and moved to filter pane and I couldn't use interactions with the filter pane.