I can't filter by [Department]

[Anonymous]

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:

 

 

One way i would be able to get what i want is getting a table like:

[Month]      [User]           [Enabled]       [Active]  ....

July             User1                  Yes              Yes     ....

July             User2                  Yes               No    ....

July             User3                  Yes               No    ....

or even:

[Month]      [Department]           [Enabled]       [Active] ....

July             Dpt1                            1051               840   ....

July             Dpt2                            2056             1492   ....

July             Dpt3                              351               298   ....

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?

Thank you very much in advance.

[Anonymous]

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

[Anonymous]

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.