Forum Discussion

sanjanarama's avatar
sanjanarama
Icon for Resolver I rankResolver I
4 years ago

help in waterfall model


I want the result in above water fall , each of the catergory is a seperate measure. how can i achive it. I tried google but i was not able to get to this result, anyone can help me?

Need Help

3 Replies

  • SolomonovAnton's avatar
    SolomonovAnton
    Icon for Super User rankSuper User
    4 years ago

    hello 

     

    you should create table with names for axis X (invoice price, RPU, net price etc)

    after it create measure like:

    SWITCH(SELECTEDVALUE('new table'[name axis x]),
	"invoice price",[invoice price],
	"RPU",[RPU],
	"net price",[net price],
	etc)

     

    or use Calculation groups 

    • sanjanarama's avatar
      sanjanarama
      Icon for Resolver I rankResolver I
      4 years ago

      SolomonovAnton 
      I tried above method and im getting as below output


      data is here :

      QuartercustomerfamilydescriptionInvoice priceRPUNetPriceCostMargin
      2021Q4New InfoFamily one1234160.00-4.33333155.66678150.6667
      2021Q4New InfoFamily one1234164.00-1015410134
      2022Q1New InfoFamily one1234160.00-915135111
      2022Q1New InfoFamily one1234164.00-58.0467105.953342100.9533
      2022Q2New InfoFamily one1234160.00-8.62993151.370118151.3701
      2022Q2New InfoFamily one1234164.00-5.97458158.025414100.0254


      My Sort order table:


      My measure for values in waterfall chart:

      Bridge = SWITCH(SELECTEDVALUE(SequenceTable[Sort]),
          1,[InvoicePrice],
          2,[RPUa],
          3,[NetPriceA]
      )




      My model output:

       

      • v-xiaotang's avatar
        v-xiaotang
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi sanjanarama 

        I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

        If you need more help, please let me know.

         

        Best Regards,

        Community Support Team _Tang

        If this post helps, please consider Accept it as the solution to help the other members find it more quickly.