stacked bar graph, using multiple columns with same categories

[iGi]

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

[v-jiascu-msft]

Hi @iGi,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[iGi]

@Dale Haven't had a chance to test it yet, unfortunately. I was having some trouble understanding. 

[v-jiascu-msft]

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