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,
I'm showing the last 12 months( last month is May 2020 ) data but I'm unable to show order like from start to end (June to May)
See the graph : (There is no data for some months so it's ok if some months are not in the graph)
So actual graph order: September, November, May, July, January, December, April
What I want: July, September, November, December, January, April, May
What I already did till for order :
1.Try to change the sort by rank column but got this error :
2.Also, I can show perfect order if I add the year from Date Hierarchy but its add year in the axis which I don't want like this: May 2020
I attach a file please take a look: testFile.pbix
Thanks In advance
Solved! Go to Solution.
Hi @mohittimpus -
First, use "month" from the Date table, not the Sales table
Second, you can put RankRange in the Tooltip field for that visual, then sort by Rank Range using the 3-dots in the corner of the header.
Hope this helps
David
Hi @mohittimpus -
First, use "month" from the Date table, not the Sales table
Second, you can put RankRange in the Tooltip field for that visual, then sort by Rank Range using the 3-dots in the corner of the header.
Hope this helps
David
Thank you so much. it works and I choose an only nonblank value in the filter so I Get What I want.
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |