How to organise LEGEND when using Date Months Hierache

[DaleK]

Hi

At present I have the following months displayed.

Jun 20, Jul 20, Aug 20, Sep 20, Oct 20, Nov 20, Dec 20, Jan 21

As I have the filter set to months and I guess the visual does not take year into consideration.

[Anonymous]

@DaleK - You can concatenate Year & Month in a singke column and use that column as legend.

This will work the way you want.

[amitchandak]

@DaleK , Are you talking about sort order. For month you need a sort column and sort on that

refer : https://www.youtube.com/watch?v=KK1zu4MBb-c

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