Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying to reproduce this chart (created in Excel) within 1 visual in PowerBI:
It looks a bit messy, but it's a clustered column chart, clustered by OU and each column is a count of AD accounts per month of the year.
Quite easy to do in Excel, but I'm really struggling to bring it over into PowerBI within 1 visual. I was able to replicate it by laying 15 visuals on-top of a blank chart visual but... that's not ideal.
The issue I'm running into is that I've had to transpose the data source so that I can use the date field in a relative visual filter (to avoid seeing too much data). What this does is stop me being able to cluster by OU and instead I have to cluster by date, which isn't the same and doesn't provide the same visual detail:
If I don't transpose I have to manually click each date I want to see in the visual, which isn't suitable as I'm hoping to use this dashboard as a replacement to my manual monthly reporting duties.
Has anyone had the same issue and come up with a workable solution?
Solved! Go to Solution.
Hi @Anonymous ,
Sorry for the delay.
For your image, I'm afraid that you need to Unpivot your columns from OU1...OU10 in Query Editor, then you could create the visual in power bi desktop.
You could have a reference of the example below.
Then you could create your desired output with Attibute column and Value column.
Hope this can help you.
Best Regards,
Cherry
Hi @Anonymous ,
More details will be helpful.
If it is convenient, could you share your data sample which could reproduce your scenario so that we could copy and have a test on it.
Best Regards,
Cherry
My apologies - the data source is a CSV that once imported and transposed looks like this:
Hi @Anonymous ,
Sorry for the delay.
For your image, I'm afraid that you need to Unpivot your columns from OU1...OU10 in Query Editor, then you could create the visual in power bi desktop.
You could have a reference of the example below.
Then you could create your desired output with Attibute column and Value column.
Hope this can help you.
Best Regards,
Cherry
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |