Data for a Stacked Bar chart

[AFinster]

Greetings all,

I have a table (Depts) that shows, by department, 4 x status values (as columns: Stage 1 Completed, Stage 1 Reviewed, Stage 2 Started, Stage 2 Completed). For each row (department), each of the 4 statuses has 1 of 3 values (Completed On Time, Completed but Late, Not Started).

I also have a Matrix visual (table) of the Depts data grouped by Company and parent department showing other statistics.

I would like to show these values in a stacked bar chart, and if the user selects a particular Company or parent department in the Matrix, the stacked bar chart changes to reflect the selection(s) made.

(Sample images below)

Any help with this would be appreciated... it's been doing my head in for a while now ...

[amitchandak]

@AFinster , You can use status or Axis and Three measures and it should filter data when you click on Matrix

[AFinster]

Hi @amitchandak - any more thoughts on what these measures would look like?

[AFinster]

Hi @amitchandak - any more thoughts on an assitance with the solution you suggested?

[AFinster]

Thanks @amitchandak - any chance of helping out with the appropriate measures? I had a thought that a measure would be needed, but the DAX was making me cross-eyed 🤣!