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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
rainerpowerbi
Resolver I
Resolver I

Special logic for sorting a table

Hi,

I created a table and if I select TOP 3-Products I receive following table:

rainerpowerbi_0-1665144911458.png

If I select TOP 5-Products I receive following table:

rainerpowerbi_1-1665144948617.png


My question:
Is there a a possibilty sorting Procuct-Column
- after Measures_Sales (descending)
- WITH THE EXECPTION of ROW WITH "OTHER": this row always shall be BELOW in the table (independ of measures-amount)

Kind regards

Rainer




 



1 REPLY 1
Dinesh_Suranga
Continued Contributor
Continued Contributor

@rainerpowerbi 

Hi,

 

1 Click more option (Three dots)

2 Click Sort By

3 Select your mesure.

 

Dinesh_Suranga_0-1665148369267.png

Thank you

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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