Forum Discussion
Helper IDouble grouping X axis - Year/month - visualization
You need to change the Concatenate label setting on the X-Axis.
Then ensure you have expanded the hierarchy on the visual
Some times you will also need to correct the sort order
Its a good modeling practice to have a seperate date dimension in your data model. This table should include a rich set of date fields that you can use in your reporting. One of the features would be to add an additional column that define the sort order of your months e.g. 1 = Jan etc... You then need to assign this sort order field to the month label to ensure they are sorted in the correct way.
Hope this makes sense.
You need to change the Concatenate label setting on the X-Axis.
Then ensure you have expanded the hierarchy on the visual
Some times you will also need to correct the sort order
Helper IHello Anonymous ,
Thanks ! your answer was very helpful. Just a question, I have now an issue of sorting on X axis. I would like 2018 on the left hand side and the months increasing from left to the right. Can you help on this ?
Thanks :)
- LucienF38
I am able by clicking "sort ascending" to have 2018 on the left and 2019 on the right but the months are not sorted as you can see below :
Its a good modeling practice to have a seperate date dimension in your data model. This table should include a rich set of date fields that you can use in your reporting. One of the features would be to add an additional column that define the sort order of your months e.g. 1 = Jan etc... You then need to assign this sort order field to the month label to ensure they are sorted in the correct way.
Hope this makes sense.
- LucienF38
Well okay I understand that maybe it is easier to sort with numbers than with letters for PBi. I created a column from example with the following formula :
= Table.AddColumn(#"Removed Blank Rows", "Colonne date pour graph", each Text.Combine({Date.ToText([Quote Date], "MM"), " - ", Text.Proper(Date.ToText([Quote Date], "MMMM"))}), type text)And it works but it creates in the graph months which shouldn't be here such as from August to December 2019 as you can see below. I tried to filter it but it doesnt work as I don't have the options August to December 2019. How can I solve his ?
Thanks in advance