Forum Discussion

Pbiuserr's avatar
Pbiuserr
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Please 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 ), ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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

  • Pbiuserr's avatar
    Pbiuserr
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    Hey amitchandak 

    I figured the same thing however thank you for your help!