Date with 2 years in graph

[Vanessa250919]

Hello, I have one issue with my date. I created a hierarchy and I need in my graph First 2020 and after 2021 and If a expand to next level all my data is mixed ... It's possible to show 2020 and after 2021 ?

[amitchandak · Accepted solution]

@Vanessa250919 , i think the sort order is not correct. Create the column in a date table/table with the correct sort column.

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

In this case you have mark Month Year sort as a sort column for Month Year 

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

Also you can check concatenate label off with sort on axis columns 

[amitchandak · Accepted solution]

@Vanessa250919 , i think the sort order is not correct. Create the column in a date table/table with the correct sort column.

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

In this case you have mark Month Year sort as a sort column for Month Year 

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

Also you can check concatenate label off with sort on axis columns 

[Vanessa250919]

@amitchandak  It's possible with week ? 

[Vanessa250919 · Accepted solution]

And it's possible to used a hierarchy  ? @amitchandak