98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Month Order in charts and line diagrams
Month Order in charts and line diagrams
Resolved · High Priority · Version 365
Mon 11 Mar 2024, 11:00Delegate Shilpi said...
Shilpi has attended:
Power BI Modelling, Visualisation and Publishing course
Month Order in charts and line diagrams
Our FY starts in August and I have used the date file that Jens provided. I cannot seem to sort the data by True month.
Mon 11 Mar 2024, 12:42Trainer Jens said...
RE: Month Order in charts and line diagrams
Hi Shilpi,
Thank you for the forum question.
I need a little bit more information.
Do you want a visual to have a date hierarchy where you have the year and then the months on the next level starting from August, September, October............. and ends with July.
Within each year the months are from August to July.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Mon 11 Mar 2024, 13:33Delegate Shilpi said...
RE: Month Order in charts and line diagrams
The chart is by month but there is a Financial year filter. I want the chart to update with the chosen financial year.
Mon 11 Mar 2024, 13:49Trainer Jens said...
RE: Month Order in charts and line diagrams
Hi Shilpi,
I have just in the data model we used on the course created a chart. I have added calendar year and calendar months and a sales measure to the chart. I dragged FiscalYear from my date table into the filter pane and filtered by one FisCal year.
My chart displayed what I expected the months from April to March (my first month in the new financial year is April).
What would you like the chart t display?
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Mon 11 Mar 2024, 13:54
Edited on Mon 11 Mar 2024, 13:59Delegate Shilpi said...
RE: Month Order in charts and line diagrams
I have my start month set at 8 which has given me August as the Trust Month 1. I was expecting to see August to July in my charts but is giving me random months. It is not even in alphabetical order.
Mon 11 Mar 2024, 14:06Trainer Jens said...
RE: Month Order in charts and line diagrams
Hi Shilpi,
You will have to change the Excel date table.
In the FisCalYear column change the formula:
="FY"&Dates!$C2+IF(MONTH(B2)>3,1,0)
to:
="FY"&Dates!$C2+IF(MONTH(B2)>7,1,0)
In the FisCalQ change the formula:
="FQ"&CHOOSE(Dates!$E2,4,4,4,1,1,1,2,2,2,3,3,3)
to:
="FQ"&CHOOSE(Dates!$E2,2,3,3,3,4,4,4,1,1,1,2,2)
In the FisCalM column change the formula:
="FM"&MONTH(EDATE(B2,9))
to:
="FM"&MONTH(EDATE(B2,5))
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Optimize Report PerformancePay attention to report performance by optimizing your data model and report design. Use the Performance Analyzer tool to identify bottlenecks in your report and improve loading times. Techniques such as using summarisation, avoiding unnecessary visuals, and optimizing DAX queries contribute to a faster and more responsive report. |
