Forum Discussion
User input for each row
Hi Jessica_17,
Thank you for reaching out to Microsoft Fabric Community.
Based on the requirement, please follow the below steps:
- Add a SortOrder column to your table like assign a number to each category to define the desired order.
- In power bi, go to Data view, select the Category column --> click on Sort by Column --> choose SortOrder.
- In the stacked bar chart use Category as the Legend. Now the legend will appear in the custom sort order which is defined.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
HI v-achippa ,
Thanks for that. However, my main requirement is that the user should be able to manually enter or adjust the sorting order for each row directly within the Power BI UI—without relying on external sources like SharePoint, Excel, or manual dataset updates. Is there any way to make the sorting dynamic and editable by the user within the report itself?
Hi Jessica_17,
Currently power bi does not support direct user input into fields like sort order from within the report UI. Users cannot manually change column values like sort order directly inside a visual or dataset in a published report.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
HI v-achippa
Is there any workaorund for it, to make it possible?
