Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi guys,
I have watched a lot of videos and tried to follow online guidance on here but I still can't seem to get my graphs to order in financial year order (April first). I understand I need to have a new column with month numbers but struggling with the coding for this too...Any help is much appreciated. See below for my current data and graph.
Solved! Go to Solution.
Easy as:
1. Enter Data - copy and paste this table
Month | Financial Order |
January | 10 |
February | 11 |
March | 12 |
April | 1 |
May | 2 |
June | 3 |
July | 4 |
August | 5 |
September | 6 |
October | 7 |
Novermber | 8 |
December | 9 |
1.5 - In the Data view, click on your new Month column, Sort Column By - "Financial Order
2. In your Model View - link the two Months columns - bidirectional one to many relationship.
3. In your chart, drag the Months from your new table as the x axis.
Easy as:
1. Enter Data - copy and paste this table
Month | Financial Order |
January | 10 |
February | 11 |
March | 12 |
April | 1 |
May | 2 |
June | 3 |
July | 4 |
August | 5 |
September | 6 |
October | 7 |
Novermber | 8 |
December | 9 |
1.5 - In the Data view, click on your new Month column, Sort Column By - "Financial Order
2. In your Model View - link the two Months columns - bidirectional one to many relationship.
3. In your chart, drag the Months from your new table as the x axis.
Hi Len,
Thanks for your help. For some reason it is dispalying as not valid. Any ideas?
@Len_Barr Got it, I accidentally had them linked to other columns in model view.
Now I believe I have everything as you have said...but still no luck with graph. Any ideas?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!