Forum Discussion
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...
Greg_Deckler
Community Champion
Community ChampionAnonymous - It is under Conditional Formatting oddly enough.
Yes, I Can see that option, but it looks like it will not fulfil my requirement.
- Greg_Deckler
OK this was what I was able to pull together. It's rough and needs work. I couldn't understand how the Age Group column factored in to this so I just kind of went with some data. I'll give you the code. It "works", it's not what I would call pretty. Attached a PBIX but you won't be able to open it unless you upgrade to April 2020.
SVG Stacked Data Bar = VAR __Table = 'Table' VAR __Total = MAX('Table'[Average of Duration]) + MAX('Table'[count of projects]) VAR __Color1 = IF(MAX('Table'[Average of Duration]) > MAX('Table'[count of projects]),"Red","Green") VAR __Color2 = IF(MAX('Table'[Average of Duration]) > MAX('Table'[count of projects]),"Green","Red") VAR __Min = MIN(MAX('Table'[Average of Duration]),MAX('Table'[count of projects])) VAR __ShapeWidth2 = __Min / __Total * 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 __SVGI'm sorry the underlying data used to derive the table report as below.
Approver ProjectID Duration a1 p1 2 a1 p2 4 a1 p3 10 a2 l1 1 a2 l2 1 a2 l3 1 a3 f1 15 a3 f2 15 a3 f3 20 a3 f4 20 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"))I just created a new measure and applied your code. I am getting the text only instead of bars.