Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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?
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
49 | |
42 | |
39 | |
38 |