Forum Discussion
Dynamic order in stacked bar
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
Super UserHi 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.
- FBergamaschi
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
- danextian
Are you trying to sort the categories in descending order based on the total value but "other" should always be the last one?
hello, yes, correct. That's exactly what I'm looking for.
