Forum Discussion
Pbiuserr
Post Prodigy
Post ProdigyPlease help to recreate a chart
Hello,
I'd like to have chart like that.
I've calculated backlog days using calculating column
blogdays =
IF (
ISBLANK ( 'data'[RESOLVED] ),
DATEDIFF ( 'data'[CREATED], TODAY (), DAY ),
DATEDIFF ( 'data'[CREATED], 'data'[RESOLVED], DAY )
)
My entire backlog measure is
blog =
CALCULATE (
COUNTROWS ( 'data' ),
FILTER (
'data', NOT ( ( 'data'[status] ) IN { "Closed", "Resolved" } )
)
)
Chart needs to looks like that
Any ideas? Thank you for your help
Pbiuserr , Create a new column
Bucket = Switch( True() ,
[blogdays] <= 14, " < 14 Days",
[blogdays] <= 30, " 15 to 30 Days",
[blogdays] >30, " > 30 Days")
And use that in visual on axis
2 Replies
- amitchandak
Super User
Pbiuserr , Create a new column
Bucket = Switch( True() ,
[blogdays] <= 14, " < 14 Days",
[blogdays] <= 30, " 15 to 30 Days",
[blogdays] >30, " > 30 Days")
And use that in visual on axis
PbiuserrHey amitchandak
I figured the same thing however thank you for your help!