Forum Discussion
How to sort Month in Dynamic Change Axis ? Sorting Month name
Thanks a lot for helping me but For Dynamic change Axis Month to QTR / QTR to Month switch with sorting by Month name I have wrote below dax query:
DimTable =
ADDCOLUMNS(
UNION ( CROSSJOIN(DISTINCT('Month'[Month Period]), DATATABLE("AxisDimension", STRING, { {"Month"}}), DISTINCT(Quarter[Quarter Period])),
CROSSJOIN(DISTINCT('Month'[Month Period]),DATATABLE("AxisDimension", STRING,{ {"QTR"}}), DISTINCT('Quarter'[Quarter Period])))
,"AxisValue", SWITCH([AxisDimension], "QTR", FORMAT(Quarter[Quarter Period], "0000"),"Month", 'Month'[Month Period])
,"AxisSort", SWITCH([AxisDimension], "QTR", CONCATENATE( RIGHT(Quarter[Quarter Period],4), CONCATENATE("0", RIGHT(LEFT(Quarter[Quarter Period],2),1))) ,"Month", CONCATENATE( RIGHT('Month'[Month Period],4), SWITCH(LEFT('Month'[Month Period],3), "Jan", "01", "Feb", "02", "Mar", "03", "Apr", "04", "May", "05", "Jun", "06", "Jul", "07", "Aug", "08", "Sep", "09", "Oct", "10", "Nov", "11", "Dec", "12")))
)
Hi mdaamirkhan,
I am afraid I cannot but what do you need it for, you have all the information you need ? Is there something you don't understand ?
Regards,
L.Meijdam
Its not working that why I need help if you do on my pbix file and share with me then it will be easy to understand. Kindly please me.
Hi mdaamirkhan,
If the only thing you can say is "Please do it for me on my PBIX" I am afraid I can't help you.
Have a good day,
L.Meijdam
ok send the qery where I will create tell me the steps and you are also only sharing the screenshot and you are not saying the steps with query like other people do