Forum Discussion
Solved
dynamic custom sort on month
Hi, Problem: trying to get the x-axis column chart to dynamically sort on user selection based on date slicer --> mat, fiscal year, production year, budget... there are other periods... As of Feb, ...
use the rankx measure for each sort order column:
How to sort by multiple columns in Power BI [Table Visual Examples] - SPGuides
but unfortunately we still cant hide columns in the chart! lol, have to use formatting 😞
Hi, it doesn't really answer my question.
I already have a sort order column for these custom periods.
how can the axis be sorted in the correct order by user selection?
Did you ever find a solution to your question?
no, but would like to.
use the rankx measure for each sort order column:
How to sort by multiple columns in Power BI [Table Visual Examples] - SPGuides
but unfortunately we still cant hide columns in the chart! lol, have to use formatting 😞