Forum Discussion
power bi
Hi Everyone,
i am trying to sort my visual by month. i have created a calendar table and created a relationship and sort it by month number but i cant set this sorting to default because i dont get the option, can anyone please help ?
i dont see modelling tab option when i go to my month table, i only see column tools but there i cant sort month number to default.
3 Replies
does the month field in the visual come from Table2, which you sorted?
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523you did the correct one but one more thing wat to do is in that visual click the more option and again click the sort axis and you select month in asc it will be sorted in correct way.
Hi!
wat you done is cool but one more thing you need to do is in the visual you will see more option in that you have to click sort axis in order to sort month by asc it will be achieved as per your requirement.
