Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
you 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.
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-...
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/1447...