I can't filter by [Department]

Question

I am working with the Microsoft 365 Usage Analytics template and i want to visualize data filtered by 'UserState'[Department]. This should be easy to do, but there is a problem: data showed by the template is not connected in such a way it allows this type of filtering. This leads to a situation where, no matter what department's values i want to visualize, i see the same. To make it easier to imagine:&nbsp;&nbsp;  &nbsp;One way i would be able to get what i want is getting a table like:&nbsp;[Month] &nbsp; &nbsp; &nbsp;[User] &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Enabled] &nbsp; &nbsp; &nbsp; [Active]&nbsp; ....July &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; User1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes&nbsp; &nbsp; &nbsp;....July &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; User2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No&nbsp; &nbsp; ....July &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; User3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No&nbsp; &nbsp; ....&nbsp;&nbsp;or even:&nbsp;[Month] &nbsp; &nbsp; &nbsp;[Department] &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Enabled] &nbsp; &nbsp; &nbsp; [Active] ....July &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dpt1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1051&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;840&nbsp; &nbsp;....July &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dpt2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2056&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1492&nbsp; &nbsp;....July &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dpt3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 351&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;298&nbsp; &nbsp;....&nbsp;&nbsp;So my question is: Is there any way i can have access to my tenant's licenses usage in a way i can get data similar to what i have showed?&nbsp;Thank you very much in advance.

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
If I understand correctly, it seems that you want to display the fields on the visuals dynamically base on&nbsp;[Department]. Am I right?&nbsp; 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

anonymous · Answer

Hello&nbsp;Anonymous&nbsp;,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&nbsp;[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?&nbsp;Thank you for replying my oiriginal question.

Forum Discussion

I can't filter by [Department]

2 Replies

Related content

Filtering a table on the Max date by department

Discharge department

Flow Map, departing

Calculating FTE per department with Department movements

Filter