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
Anonymous's avatar
Anonymous
Not applicable
6 years ago
SVG Stacked Data Bar =
VAR __Table = 'my'
 
VAR __Color1 = IF (AVERAGE(my[<3 age group])=1,"Green") VAR __Color2 = IF (AVERAGE(my[>3 & <6 group])=1,"Yellow","Red")
VAR __ShapeWidth2 = count(my[ProjectID])*500
VAR __header = "data: image/svg+xml;utf8," &
"<svg xmlns='http://www.w3.org/2000/svg' x='0px' y='0px' width='" & "500" & "' height='210'>"
VAR __footer = "</svg>"
VAR __shapeTextSquare1 = "<polygon points=""0,200 " & "500" & ",200 " & "500" & ",0 0,0"" style=""fill:" & __Color1 & ";stroke:" & __Color1 & ";stroke-width:0;fill-rule:evenodd;"" />"
VAR __shapeTextSquare2 = "<polygon points=""0,200 " & __ShapeWidth2 & ",200 " & __ShapeWidth2 & ",0 0,0"" style=""fill:" & __Color2 & ";stroke:" & __Color2 & ";stroke-width:0;fill-rule:evenodd;"" />"
VAR __SVG = __header & __shapeTextSquare1 & __shapeTextSquare2 & __footer
RETURN
__SVG
 

i'm getting like above which is not correct.

 

'Age Group' is not applied, BAR length is also very small.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greg_Deckler , Can you look into the issue please and provide the solution?

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

  • 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 , 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??