Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Quarter comparision chart

Hi Team,

 

I would like to knwo how to achieve the below chart in power bi

 

 

Regards,

Husna

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Assume Qtr-Year on Axis and the other group by on category, you should get like this

     

    Sort qtr year on Qtr Year sort

    Qtr Year = "Q" & QUARTER('Date'[Date]) & " - " & YEAR('Date'[Date])

    Qtr Year Sort = FORMAT('Date'[Date],"YYYYQ")

     

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Assume Qtr-Year on Axis and the other group by on category, you should get like this

     

    Sort qtr year on Qtr Year sort

    Qtr Year = "Q" & QUARTER('Date'[Date]) & " - " & YEAR('Date'[Date])

    Qtr Year Sort = FORMAT('Date'[Date],"YYYYQ")