Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Handling multiple financial year implementation in a model

Hi Team, 

 

I have multiple FY based on a attribute in a model i am facing the issue in sorting the visuals based on Months and Quarters.

Any help would be appreciated. Below is some demo data for the same.-

Customer NameSalesAmountYearMonthSortOrder
AAA196102018071
AAA129452018082
AAA141122018093
AAA124272018104
AAA187232018115
AAA181452018126
AAA104132019017
AAA102122019028
AAA134442019039
AAA1284520190410
BBB107232018041
BBB149182018052
BBB167412018063
BBB137472018074
BBB137402018085
BBB150142018096
BBB190172018107
BBB151172018118
BBB144152018129
CCC199292018101
CCC118122018112
CCC175322018123
CCC156122019014
CCC143182019025
CCC124172019036
CCC159322019047
CCC159122019058
CCC127212019069
CCC1392420190710

 

6 REPLIES 6
v-yiruan-msft
Community Support
Community Support

Hi @Anonymous ,

What's your expected result? Do you want the records sorted by the value of column "SortOrder"? What's your issue? Could you please provide the relevant screenshots? 

 

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

snapsnap

Hi @Anonymous ,

Please applied the field "SortOrder" as Tooltips field into column chart, and sort the visual data by this field.

SORT2.jpg

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-yiruan-msft ,

 

I have tried that trick, but the problem with keeping the sort order to tooltip pane is it summarize the column(sort_order)

and could show the wrong sorting order.

 

 

Hi @Anonymous ,

Whether your problem has been resolved?

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @Anonymous ,

Could you please provide your sample PBIX file(exclude sensitive data) if it is convenient?

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.