Forum Discussion
Post ProdigyNeed to add add Month Sort Order to table
I have existing table with all Date Columns as Whole Numbers. I introduced a Month Text Field for Column Charts, but now I need to be able to sort months in Month order.
How do I accomplish that?
bdehning ,
Step 1: Create a Month Table with Month name and Month Sort Order.Step 2: Sort your Month name by month sort order.
Step 3: Connect this table with month of existing table.
Step 4: Pull this new Month name field into chart.
Check the solution of this query: https://community.fabric.microsoft.com/t5/Desktop/Sort-two-Columns-in-Matrix-Table/m-p/3226747
4 Replies
- Anand24
Super User
bdehning ,
Step 1: Create a Month Table with Month name and Month Sort Order.Step 2: Sort your Month name by month sort order.
Step 3: Connect this table with month of existing table.
Step 4: Pull this new Month name field into chart.
Check the solution of this query: https://community.fabric.microsoft.com/t5/Desktop/Sort-two-Columns-in-Matrix-Table/m-p/3226747
bdehningIs there a way to add something to existing table to make this work?