Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
i in my matrix the month are displayed from number 1 to 11 January -November
i dont find the way to display instead 1-11
January -November how i can do?
Solved! Go to Solution.
Hi @snifer,
You could use Sort by column to achieve your desired output.
Here is my test output.
Best Regards,
Cherry
for something like this the texts January-November actually have to be in some column
if you don't have one you can create a calculated one based on existing Month e.g.
MonthName = FORMAT(Date(2020,Table[Month],1),"MMMM")
you just need to replace the blue text to match your naming convention
it worked but problem is that if i use now the measure the month are not displayed in the correct order in the matrix check screenshot
how i can fix that displaying from January Decemberember and not alphabatically
Hi @snifer,
You could use Sort by column to achieve your desired output.
Here is my test output.
Best Regards,
Cherry
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |