Forum Discussion
How change the axis Waterfall Ultimate Position
Resolved!
First, i created a index measure, based on ranking that already works, where i can to set the number of the index that i want to show at waterfall graph.
Index =IF([Ranking_] <= 5,[Ranking_],if(SELECTEDVALUE(Dimension_[Category])="X",0,if(SELECTEDVALUE(Dimension_[Category])="Y",7,if(SELECTEDVALUE(Dimension_[Category])="OTHERS",6))))In the graph, i've added Index measure as a tooltip, and then, order the graph based on my index measure, and it worked perfectly!!!!!!!
Community SupportHi larcaris ,
It seems that you blank the table visual, if the category is confidential, we suggest you to blank the axis in your waterfall visual also. We can create a axis table and set the sort by column to meet your requirement:
Best regards,
v-lid-msft its awesome! but my model is so hard, and because of this, i need to resolve all in a fact table.
You get me a idea, i'm thinking to do a column index in dax to resolve, it seems the best way to do it.
My ranking measure is above, but it works only to my top 5, to columns U and L it doesn't works:
I don't know if i change the total_others_3 or ranking_ measure.
Resolved!
First, i created a index measure, based on ranking that already works, where i can to set the number of the index that i want to show at waterfall graph.
Index =IF([Ranking_] <= 5,[Ranking_],if(SELECTEDVALUE(Dimension_[Category])="X",0,if(SELECTEDVALUE(Dimension_[Category])="Y",7,if(SELECTEDVALUE(Dimension_[Category])="OTHERS",6))))In the graph, i've added Index measure as a tooltip, and then, order the graph based on my index measure, and it worked perfectly!!!!!!!- v-lid-msft
Hi larcaris ,
Glad to hear that you have resolved your problem. Thank you for sharing this wonderful solution, we believe it can benefit more users. If you have any other questions about this scenario, please kindly ask here and we will try to resolve it.
Best regards,