Date hierarchy sorting by day in matrix visual

[Anonymous]

Hi All,

Does anyone know how to sort by day in date hierarchy ? I tried using sort by column but unable to get the result.

31st of last month should come first.

  

Hierarchy:-

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

You can't sort the day in the build-in date hierarchy. You need to create your own day column in the table: DAY([Date]) then use the function in the https://community.powerbi.com/t5/Desktop/Matrix-Column-Head-Order/td-p/71572  create a new index column. If you want to put it in a custom order, you can customize the index yourself. For example, you can create a conditional column in Query Editor.

And in the build-in date hierarchy. If you keep the month hierarchy the columns will what you want:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Anonymous]

Thank you for your help @v-deddai1-msft 

[Pragati11]

Hi @Anonymous ,

If you move you DAY field under ROWS section, then you get a sort order to select like shown below:

But when you move DAY to COLUMN section, then unfortunately there is no option to sort your column values.

Thanks,

Pragati

[Anonymous]

Thank you for your time @Pragati11