topic Re: Month Order for a calculated dimension table in DAX Commands and Tips

Month Order for a calculated dimension table

Winniethewinner — Mon, 13 Jun 2022 14:31:02 GMT

Hi Everyone,

I created a calculated dimension table and use it to dynamically switch the axis in the chart. Here is the calculated table DAX:

And here is the chart, which is switched based on the axis on the left:

The question I have is, the months are 7-month forwarding, i.e. I will have 07,08,09,10,11,12,01 as the next, how can I sort it properly for those months?

(because I use the calculated table for "Month" attribute, those values 07,09,09,10,11,12,01 are in text format)

Re: Month Order for a calculated dimension table

v-xiaotang — Thu, 16 Jun 2022 07:19:25 GMT

Hi Winniethewinner

Thanks for reaching out to us.

>>The question I have is, the months are 7-month forwarding, i.e. I will have 07,08,09,10,11,12,01 as the next

Because they are in text form, they cannot be sorted by themselves, so you can try sort by column. Sort one column by another column in Power BI - Power BI | Microsoft Docs

Or you can try this one, use year-month column, for example,

Best Regards,

Community Support Team _Tang

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

Re: Month Order for a calculated dimension table

Winniethewinner — Fri, 17 Jun 2022 18:12:58 GMT

Thanks v-xiaotang . I'm uploading this sample data - I'd like to sort the month properly when switching to month dimension. if I create a separate Month_table, how do I link it to the DimTable which also have other dimensions and values? Another thing is when I add relationship using Index between 2x tables, the autosum (sigma) disappears, any idea why? Thanks in advanced.