Report Usage Metrics, Filters Data ?

[pboitel]

Hello,

I'm discovering the “Usage Metrics” of my reports. I'm browsing through the data and want to know if it's possible to get statistics on the filters used.

I've found data on the users of my AD who use the report, but I'd like to know what they most often use as a filter. To illustrate, if I sell fruit, vegetables and hardware, I'd like to see if this user only looks at fruit and therefore uses this filter.

It seems a bit low-level to me, but I'd like it if it were possible.

If it's not available as data in Usage Metrics, does anyone have an idea how to get this result?

Thank you, have a good day.

[v-mdharahman]

Hi @pboitel,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-mdharahman]

Hi @pboitel,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-mdharahman]

Hi @pboitel,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help?

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.

If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

[v-mdharahman]

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.

[Sahir_Maharaj · Accepted solution]

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.