Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am having difficulties sorting my months in order for my graphs as well as my slicers.
I read that you can have a column for the month number the go to Modelling>"Sort by Column" however, it is not working for me.
I wrote some DAX to generate my month number column called "Fiscal Period Number" since there are far too many rows to type them individually (see image below)
Then I went to Modelling>Sort By Column>Fiscal Period Number while the Fiscal Period Column was selected. This notification pops up:
Sorry, I have tried to add it 3 times but it's not posting. It says:
"Sort by another Column
This column can't be sorted by a column that is already sorted, directly or indirectly, by this column"
In the table, they seem to match up:
I tried changing the column type to numbers but the same notification pops up. Is this because I created the month number column based on the month column through DAX?
Here Are some examples of my slicers and figures listing the months in alphabetical order:
Solved! Go to Solution.
Hi @MiekeV ,
You can refer to following similar case to know how to create a custom order column in Query Editor to enable sort by column feature:
You can also create a related sort table, see more: Custom Sorting in Power BI .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @MiekeV ,
You can refer to following similar case to know how to create a custom order column in Query Editor to enable sort by column feature:
You can also create a related sort table, see more: Custom Sorting in Power BI .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @MiekeV ,
You don't show what notification pops up.
Nathaniel
Proud to be a Super User!
Sorry about that!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |