Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Thank You.
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?
@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?
Hi @roma ,
Just click here marked in red:
Then you can choose sort descending or sort ascending.
Best Regards,
Kelly
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.
Hi @roma ,
Do you wanna show like below?
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
Best Regards,
Kelly
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |