Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Error applying report-level filter, in new 365 Usage Analytics report

Hi,

 

I'd like to be able to filter the new Microsoft 365 usage analytics report by country. I've added LocationCountry (UserState) as a filter on all pages. When applied however (e.g. China) the data remains aggregated for all countries. 

 

I'm sure this is the right field to filter on, and as I want to be able to filter all tabs and data shown in this report, adding as a filter on all pages is the right approach. Am I missing something in the way this new report has been built.

 

Any help would be greatly appreciated!

 

Thanks,

Rob.

2 REPLIES 2
Anonymous
Not applicable

@Anonymous|

According to your description, a possible reason of this issue is the  LocationCountry column is on a different table which is not related to the visuals you are look into. 

 

Or you can provide more details, so we can probably come out with more opinions..

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Pragati11
Super User
Super User

Hi @Anonymous ,

 

Does your "LOcation" relates to the data used for visualisation?

I mean is it in the same dataset used for creating reports on all tabs or in a different table but related to the dataset used for reporting?

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.