Forum Discussion
Helper VMonth Correct Order and status Help
Hi dommyw277 ,
1. You need to sort the Month Column in your Date Table by a Month Number. If you dont have a date table there is a lot of documentation on the topic, for example: https://radacad.com/all-in-one-script-to-create-calendar-table-or-date-dimension-using-dax-in-power-bi
In my example Month Name is sorted by Month. If you have multiple years worth of data it's probably bettr using the Month Year column.
2. Select the Status column that needs to be grouped in Column Tools select 'Data Groups' > 'New Data Group'. Then group the status as required:
Then use this new Grouped Column in the legend:
If this answer solves your problem please mark it as a solution!
Solution SageHi dommyw277 ,
1. You need to sort the Month Column in your Date Table by a Month Number. If you dont have a date table there is a lot of documentation on the topic, for example: https://radacad.com/all-in-one-script-to-create-calendar-table-or-date-dimension-using-dax-in-power-bi
In my example Month Name is sorted by Month. If you have multiple years worth of data it's probably bettr using the Month Year column.
2. Select the Status column that needs to be grouped in Column Tools select 'Data Groups' > 'New Data Group'. Then group the status as required:
Then use this new Grouped Column in the legend:
If this answer solves your problem please mark it as a solution!