Forum Discussion
Custom table with dynamic data
Hi Anonymous,
Do you want the data displayed in visual not to be affected by some specific slicers? If so, you can turn off the interaction between slicers and the visual, please see Visualization interactions in a Power BI report
If this doesn't meet your requirement, please provide sample data and show us desired output. How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu
Thanks for the response, yes I know about visual interactions - it would rather interact or not. Can in one table I can show the data about filtered and non filtered records?
If you see the example output i have provided in my original question, is that two rows in the table should come after the filter applied and two without. I can do that into two separate tables but the calculation won't be correct, is there a way to do that in one table?
If this is not possible, is there a way i can run a dymamic query use the value from the slicers?
Hope it is much clearer now.
Thanks