Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Combine Table & Stacked Bar Chart

All,   I have a requirement to develop a report like below. Just removed the approver name due to security reason, think of some names under Approver.   This is not a single chart, i just a...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

It's going to be next to impossible to troubleshoot this without the data Anonymous  - can you share the PBIX or a representative sample?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greg_Deckler 

 

Please find the mock data.

 

ApproverProjectIDDuration
a1p12
a1p24
a1p310
a2l11
a2l21
a2l31
a3f115
a3f215
a3f320
a3f420

 

Calcuated Columns/Measures:

projects>3 days = IF (my[Duration] >3, 1, 0)

count of projects = DISTINCTCOUNT(my[ProjectID])
%3 Days Outstanding = SUM(my[projects>3 days])/[count of projects]
Age Group = IF(my[Duration] <= 3, "<=3 Days",IF (my[Duration] >3 && my[Duration] < 6,"> 3 and < 6 Days",">=6 Days"))
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Greg_Deckler  Thanks, I will review and share the details what you need in few hours.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Greg_Deckler , is the same data help you to bring the expected result? can you help me on this ?

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous - Sorry, lost track of this thread. Let me take a look at the data you provided and see what I can create.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Greg_Deckler , please let me know if you find something on this.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Greg_Deckler , please provide an update on this.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous - I have updated the PBIX file with your sample data and created the columns and measures, I think, correctly. What I need to understand is what is what in your stacked bars. If this were a normal stacked bar chart, what would be the Legend and what would be the Value??