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.
Hi, Our financial year is Sep to August.
How can I get the visualizations to display our fy correctly ?
Thx
Tony
Solved! Go to Solution.
Hi, select your Month (in names) and go to Modeling Sort By Column --> Select your Month in numbers.
Next, in your visual put the Month (in Names version).
Ready.
Hi @TonyR
I had earlier posted a solution on this.
If this works please accept this as a solution and also give KUDOS.
Cheers
CheenuSing
I dont know HOW this worked, but it did. THANK YOU
Hi @TonyR,
To understand your situation, could you please provide some picture about your data structure/data table and your expectation?
So far you could
Hi Tring
Info is displaying sales data by month. I did a calaculated column similar to what you suggested . Sep is Month 1, October is month 2, Jan is month 5 etc. I can then display the monthly sales data correctly however then the labels displayed are the numeric value for the month where I want the actual month name displayed. see here as an example http://screencast.com/t/8YbgHbac
Hi, select your Month (in names) and go to Modeling Sort By Column --> Select your Month in numbers.
Next, in your visual put the Month (in Names version).
Ready.
What we do if i need to sorting FY YEAR format 2020-2021 in Line Graph ...
Month we can do but what about FY year
Thanks @Vvelarde, such a simple and quick solution. Well done and thanks for sharing it
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |