cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Enable/ Disable the sorting of Measures in Grid / Matrix View

Hi Everyone,

 

I have a requirement, where I want to only sort by STORE in below example and restrict the sorting of the other columns.

Please let me know the solution for this.

 

Capture.PNG

 

 

 

 

 

Thank You.

9 REPLIES 9
Highlighted
Anonymous
Not applicable

What do you mean exactly when you say "restrict the sorting of the other columns? What is your intended outomce in comparicon to the scrrenshot you provided?

Highlighted

@Anonymous ,

 

I just wanted to sort data through STORE Column only in the below Grid, and not with other respective columns.

In the below image you can see we can sort with STORE, COGS likewise for other Measures as well. 

I only want to the Sorting order of STORE Column. (Coming from Dimension Table). Is it possible in Power BI?

 

Image 6.png

Highlighted

Hi @roma ,

 

Just click here marked in red:

 

Annotation 2020-02-04 142045.png

Then you can choose sort descending or sort ascending.

 

Best Regards,
Kelly

Highlighted

Hi @v-kelly-msft,

 

I want the only STORE Icon to be present to sort. COGS and Other Columns should not show an icon to sort. Please refer below image.

Annotation 2020-02-04 142045 (1).png

 

Highlighted

Hi @roma ,

 

Do you wanna show like below?

 

Annotation 2020-02-04 160928.png

 

If so ,just follow the steps below: (e.g. in a table visual)

click ... then choose "sort by">select the column you wanna sort by

Annotation 2020-02-04 161037.png

 
Best Regards,
Kelly

 

 

Highlighted

Hi @v-kelly-msft,

 

I did the same as you said.abc.png

 

 

 

 

 

But Still COGS and other column shows sorting icons

xyz.png

Highlighted

Hi @roma

 

Are you using a table visual?Do you mean that others cant filter by other columns except the column you set ?If so ,it can't be realized currently,You can come up with a new idea and add your comments there to make this feature coming sooner. https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

 

 
Best Regards,
Kelly

Highlighted

Hi @v-kelly-msft ,

 

Yes, I am using table Visual.

Highlighted

Hi @roma ,

 

Currently it can only be fixed in appearance,but the function can't be restricted.You can come up with a new idea and add your comments there to make this feature coming sooner. https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Best Regards,
Kelly

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors