Forum Discussion
Dynamic order in stacked bar
Hi,
I need to show always other in the last regardless the values of Material compatible column. It's too complicated for me, I tried many option but always error, please help me.
I tried
Hi DataEnth,
good. Then it should not be a problem. You need to create a column and sort the column "Sir" based on the values of that column.
Here is my sample file to explain how I did that, Feel free to ask clarifications. You should include a column that specifies the sort order. I did that with Insert data, you can do as you prefer
https://drive.google.com/drive/folders/1oxe4dlkgSLIc5-_c3JMdILrA8z2GUMRo?usp=sharing
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
10 Replies
Hi DataEnth,
can you please explain what you are asking? This sentence
I need to show always other in the last regardless the values.
is impossible to understand
What do you mean "last"? What do you mean "regardless of the values"?
Meanwhile, if you mean you want to group some values into a single label "others" (but you should specify how many you want to group there and based on what criteria), here is a solution to this problem (which might not be yours)
https://www.sqlbi.com/articles/showing-the-top-5-products-and-others-row/
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
I mean regardless the sort by "Materiel Compatible" , "Other" is a value from the column Sir.
Hi DataEnth,
good. Then it should not be a problem. You need to create a column and sort the column "Sir" based on the values of that column.
Here is my sample file to explain how I did that, Feel free to ask clarifications. You should include a column that specifies the sort order. I did that with Insert data, you can do as you prefer
https://drive.google.com/drive/folders/1oxe4dlkgSLIc5-_c3JMdILrA8z2GUMRo?usp=sharing
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hi,
Share the download link of the PBI file.
Hi DataEnth , Thank you for reaching out to the Microsoft Fabric Community Forum.
I reproduced the scenario on my end using sample data and it worked successfully. To help you better understand the implementation, I’ve attached the .pbix file for your reference. Please take a look at it and let me know your observations.
Thank you for being part of the Microsoft Fabric Community!
Hi DataEnth , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.
Hi DataEnth , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.
Hi DataEnth , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.
