Forum Discussion

AFinster's avatar
AFinster
Helper I
2 years ago

Data for a Stacked Bar chart

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 ...

 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

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

    • AFinster's avatar
      AFinster
      Helper I
      2 years ago

      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 ðŸ¤£!