cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
farinshaikh
Frequent Visitor

How to restrict sort order in tabular view

Hi,

 

I want to show Top Performers in table and they must be in a descending order.

 

Now, what happening with my application is, whenever User mistakenly clicked on the column header, the sorting order is getting collapsed. And, Top Performers will show the buttom record first. 😞

 

Yes, I can keep some NOTES on the page regarding such cases. But, In Power BI, is there any way to restrict our table values in specific order?( i.e. If user clicked on any column header, the sorting must not be changed)

 

It will be so good, If we can able to do it.

 

Please suggest.

 

Thanks in Advance

Farin.

 

 

3 REPLIES 3
Anonymous
Not applicable

Hi,

 

I had the same issue like you. Now I have found a working solution I can live with:

 

1. Create a new text box or shape

2. Disable border, backround color and visual header

3. Put the text box or shape over the column headers

 

This will avoid that someone can click on the column headers.

 

Hope that helps!

 

Best Regards

Semih

 

v-qiuyu-msft
Community Support
Community Support

Hi @farinshaikh,

 

I'm afraid that we are not able to disable table column header sorting features to the client users currently. If we mistakenly click the column header to sort the column ascending, we can also click it to sort descending.

 

Best Regards,
Qiuyun Yu

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

Hi @farinshaikh

 

I don't think it is possible to do what you suggest for the moment. I agree it would be great 🙂

 

A few solutions I can suggest though:

- Add a column with the rank of the sales so the user can see the impact of his column header click

- Bring in some conditional formatting on the sales column to give the user a clear view on what is the current sorting

 

What do you think ?

 

Hope it helps you 🙂

 

Tristan

Data & BI consultant at AZEO

 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors