Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
Not sure where my first post went, but it doesn't look to have gone through.
I'm trying to graph the below: a stacked column graph indicating a total of scheduled vs. no-shows per facility per month. The trick is that I need multiple (in this case two) stacked column graphs for each month, because I have two facilities for which to report.
The data is simple enough: resource/month/facility 1 scheduled/facility 1 noshows/facility 2 scheduled/facility 2 noshows
Still, I'm unable to do it and it's frustrating me. Maybe I'm too close to it. Can anyone advise?
Hi @iGi,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
@Dale Haven't had a chance to test it yet, unfortunately. I was having some trouble understanding.
Hi @iGi,
Please check out the demo in the attachment.
1. Unpivot the four column in the Query Editor.
2. Split the Attribute column.
3. Create a visual. Change the settings.
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |