Forum Discussion
Report Usage Metrics, Filters Data ?
Hello pboitel,
One approach would be to try adding a hidden table in your report that records user interactions with slicers or filters. This can be done using a combination of measures and a data storage mechanism, like writing logs to a database or Power Automate workflows.
If you're using Row-Level Security (RLS), you can infer filter usage by analyzing user activity logs in Azure.
Hope this helps.
Hi pboitel,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you are trying to get the data on which filter is used but unfortunately the Usage Metrics in PowerBi doesn't provide enough information on which filters is applied by user when interacting with the reports.
In place of this you can use Log Tables to track filters usage or you can use Dynamic Parameters to track filters applied by users in PowerBi or your reporting tool. You can also go through the solution provided by Sahir_Maharaj and please accept it as a solution if it solves your problem.
If you have any other questions please feel free to contact me.
Best Regards,
Hammad.
Community Support Team
If this post helps then please mark it as a solution, so that other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Thank you.