Forum Discussion

larcaris's avatar
larcaris
Frequent Visitor
6 years ago
Solved

How change the axis Waterfall Ultimate Position

Hi guys!!

I need a help with the Waterfall Ultimate Graph.

I need to change the position of one of my cateogries,that inside of my measure. But i dont know if its posible, in this graph.

At image below its a example that i need. I have top 5 of my categories, and the sixth position are my "Others" categories.
But i needed to insert two others measures (Col L and Col U), and i need that Col U will be at the end of the x axis. Its posible to do it?

 

 

 

My measure is:

 

TOTAL_OTHERS_3 =
IF(
[Ranking_] <= 5,
[F_Total],
IF(
SELECTEDVALUE(Dim_DePara[GPO Category PBI])= "Others_Cat_Wapt",
SUMX(
FILTER(ALL(Dim_DePara[GPO Category PBI]),[Ranking_]>5), [F_Total]),
IF(
SELECTEDVALUE(Dim_DePara[COLDEPARA])= "COL L",
[F_Summary_Col_L] ,
 
IF(
SELECTEDVALUE(Dim_DePara[COLDEPARA])= "COL U",
[Summary_Col U], 0 )
)
)
)



ANY HELP is appreciated! Congrats!

Need Help
  • larcaris's avatar
    larcaris
    6 years ago

    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!!!!!!!

4 Replies

    • larcaris's avatar
      larcaris
      Frequent Visitor
      6 years ago

      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: 

      Ranking_ = RANKX(ALL(Dim_DePara[GPO Category PBI]), [F_Total], , DESC, Dense)
       
      I'm new in powerbi, and i trying to solve this problem for 1 week.
      Any help about the index column or change the ranking measure?
      I don't know if i change the total_others_3 or ranking_ measure.
      • larcaris's avatar
        larcaris
        Frequent Visitor
        6 years ago

        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!!!!!!!