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")))
)
How Sort number created if it has 3 years data
Hi mdaamirkhan,
I just looked at your PBIX file
I think you can just make a column next to it that goes from 1-36 after that you can sort on that column that should probably give what you want.
Regards,
L.Meijdam
Can you please please help me on this on my pbix file it will be great
Hi mdaamirkhan,
If you add a column like this:
You can configure your visual like this:
If you follow these 2 steps it should work fine in your situation, I believe you can do that yourself.
Regards,
L.Meijdam
can you please share the file with this please and how you create a ID