Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
How can I change the order and view of months on the x-axis on a graph?
I need to display financial YTD sales information. I have used the time intelligence functions to create a new column to display this for me which works as I wish. However, when I come to display this information it starts from January and extends to December (which as this hasn't occured leaves a plateau in the graph).
Either I need to display from april (the start of our financial year) to the current month, or from last year to the current month. E.g as it is august 2019, the x-axis should run from September-18, to August-19. Next month that would then change accordingly.
I am new to Power BI so please as much information as possible would be fab.
Thanks in advance,
Colleen
Solved! Go to Solution.
Here's how I would do it:
You should end up with something like this:
Ah, I see. It's because of your measure formula. Here's what I think are your options:
Here's how I would do it:
You should end up with something like this:
I admit I missed something sorry @pbeye !
Having returned a bit more fresh faced this monday I've realised my graph only spans from April to December as shown:
The display worked fine for when I was only looking at this year as it ran April to July (most recent month with data).
Please what do I need to do for mine to run the full 12 months until March (the end of our financial year)? I've followed the steps exactly with this outcome.
Kind regards,
Colleen
Hi @Colleen ,
I suspect it has something to do with your filters or your fiscal year formula. Can you provide an example for each of those?
Hi @pbeye ,
This is how I calculate my YTD values
Sales YTD Fiscal = TOTALYTD( SUM('Raw Data'[LineTotExcl]), 'Raw Data'[TxDate].[Date], "31/3" )
And here are the filters and data values on the visual:
Thank you so much for your continued help!
Kind regards,
Colleen
Ah, I see. It's because of your measure formula. Here's what I think are your options:
Ah thank you for that clafication.
I've seen online about making custom calendars and It looked very tricky to understand, but I guess that will have to be that way! Time to do some scraping. Cheers
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |