Stacked Bar Chart Two Columns

Data Visualizations
1

I was wondering if it was possible to have a stacked bar chart from two DAX Measures or adding two additional columns in my tables. This is very simple in excel by doing SUMIFs off the main table and then doing a chart off of those values.

I’m wanting to stack scheduled hours and unscheduled hours so it visually shows how much of professional service hours are scheduled

Stacked Bar Chart Excel
Stacked Bar Chart Excel558×640 9.77 KB

Thanks,

James Dennis

2

Hi @james8992

If this is what you are looking for

Unsceduled-scheduledHours
Unsceduled-scheduledHours1371×479 49.3 KB

There are two measures
Unscheduled Hours = Sumx(Hours,Hours[Unscheduled Hours])
ScheduledHours = Sumx(Hours,Hours[Scheduled Hours])

Then you can drag the Project Manager in the Axis Field and these 2 measures in the Values field. ( I have only entered some data from your snapshot so it is not showing everything).

Please let us know if it works.

Regards

Najah

3

Well that was humbling. I had a value already in the “Legend” and it only would allow one value in the Value. Once I removed it, it totally worked.

Thank you so much Najah for the quick reply.

1 Like
4

You are most welcome @james8992, I am really happy that it worked for you :slightly_smiling_face:

Have a good day

Najah