The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
@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.
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