Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
I have a table with the column called Month, values are as: Jan, Feb, Mar ... Dec.
I need to sort graph by Month.
Graph is made up of Revenue and Month.
Your help will be appreciated.
There is not date column in the table. Thanks
Solved! Go to Solution.
Hi @sdhn
You can still sort by month by creating a 'Month Number' Index Column and sort the Month Column within the table using the 'Month Number' column.
If the existing table has many rows, it may affect the speed with a new column created, so if that is the case I would suggest you to create a new table and establish a relationship between the two.
Hope this helps! If you need any clarification, feel free to reply.
Please Accept this as a solution if you think I answerd your question.
Thanks
Mahesh
Solution:
We completed the following steps:
Solution:
We completed the following steps:
Hi Mahesh ,
I tried did not work as below.
1) I created a table sort .
I uploaded this table onto current report.
But currrent existing table has multiple rows for Feburay, March, April & May. No other Months as below:
sample data
I added Month # in the existing table.
Sample data
here is the relationship
But not getting graphs correctly still. Am I missing some thing? Thanks
No
Hi @sdhn
Have you solved this problem? After sorting Month column by Month# column, it should work. Sort one column by another column in Power BI Desktop
Best Regards,
Community Support Team _ Jing
see below
Hi @sdhn
You can still sort by month by creating a 'Month Number' Index Column and sort the Month Column within the table using the 'Month Number' column.
If the existing table has many rows, it may affect the speed with a new column created, so if that is the case I would suggest you to create a new table and establish a relationship between the two.
Hope this helps! If you need any clarification, feel free to reply.
Please Accept this as a solution if you think I answerd your question.
Thanks
Mahesh
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |