Forum Discussion
stacked bar graph, using multiple columns with same categories
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?
Sketch
3 Replies
- v-jiascu-msftMicrosoft Employee
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 - v-jiascu-msftMicrosoft Employee