Forum Discussion
I can't filter by [Department]
Hi Anonymous ,
If I understand correctly, it seems that you want to display the fields on the visuals dynamically base on [Department]. Am I right? But what's the backend logic? Which fields every department should display separately?
Customize the reports in Microsoft 365 usage analytics - Microsoft 365 admin | Microsoft Learn
Best Regards
Hello Anonymous ,
the fields i want to show splitted by [Department] are the Users Usage columns, such us [Enabled Users] [Active Users] etc. After some research, this is most likely impossible to do from the inside of the pbix since it does not exist any relationship between both fields (because [Department] is related to [User], meanwhile [Enabled Users] is just a number, meaning the "ID" is lost somewhere and became just a "+1"). So now what im hoping to find is a way to access the process that makes the "ID" become a "+1". For that purpose, I have tried using microsoft graph but even that seems to not be the solution. Is there any way to recover the [User with row ID is enabled], [User with row ID was active in row month] or something like that?
Thank you for replying my oiriginal question.