Forum Discussion
krist_pbi
3 years agoHelper I
Order axis for matrix visual
Hi community, I need help with the following, is there a way I can sort the column axis (dates) from oldest to newest but from left to right? It doesn't let me do it, I have a client that doesn't...
HoangHugo
3 years agoSolution Specialist
Hi, you can create an extra column to rankx your date in order of Asscending
extra column = RANKX(your table, date column,,1)
then you sort your date colum by extra column, an the matrix will show expected result.