Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
1 year ago
Solved

hi

hello   doest any one has any web link or any guide how to build Piano Chart YoY in power bi?    if can help me step by step will be greatefull   thanks
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    1 year ago

    abc_777 I put this together. PBIX is attached below signature. I think it's pretty close to what they had in the post. I'll try to make a video on it.

     

     

  • abc_777's avatar
    abc_777
    1 year ago

    Hello Greg_Deckler ,

     

    thanks man, this is the one i was looking for. when create vedio clip request u please share me.

     

    i just have a little quiry rather make 

    Measure = 20000000
    Measure 2 = IF( [MOM] > 0, 20000000 )
    Measure 3 = IF( [MOM] < 0, 20000000 )  static,  cant we make them dynamic?
     
    and i dont see the use of followings
    MOM Neg = IF( [MOM] < 0, [MOM], BLANK() )
    MOM Pos = IF( [MOM] > 0, [MOM], BLANK() )
     
    would you mind to help me out please
     

     



    thanks

Greg_Deckler's avatar
Greg_Deckler
Community Champion
1 year ago

abc_777 Can you post an example of a Piano Chart? Not familiar with that chart type.

    • abc_777's avatar
      abc_777
      Solution Specialist
      1 year ago

      no luck?

    • Thejeswar's avatar
      Thejeswar
      Super User
      1 year ago

      Hi abc_777 ,

      As far as I know, there is no in-built piano chart available in Power BI.

       

      However if you see this post, they are mentioning that they are using a Line and Clutered Column Chart visual for this purpose

       

      Here what they should have done to get this,

      in the line chart they have hid the line and enabled the markers and added a error bar that starts from x-axis. Since the clustered column and error bars are of the same colour, you don't explicitly see it.

      I built a quick visual with my data. Sharing it below

       

      You just have to play more with innovative way to format your visual to get to exact similar look and feel

      Hope this helps

       

      Regards,

      • abc_777's avatar
        abc_777
        Solution Specialist
        1 year ago

        Thejeswar Thanks for you reply. As u were able to do would you mind to help me using my sample data please? if would be goo to have % of growth at marker using red and green color like i gave u the image. 

         

        Will be greate ful to you

         

        YearMonthItem nameItem Quantity
        2023JanuaryA2
        2023Februaryb4
        2023Marchc2
        2023Aprila3
        2023Mayb4
        2023Juned5
        2024Julyb6
        2024Augusta4
        2024Septemberc3
        2024Octobera2
        2024Novemberb4
        2024Decembere3



        thanks

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      1 year ago

      abc_777 I put this together. PBIX is attached below signature. I think it's pretty close to what they had in the post. I'll try to make a video on it.

       

       

      • abc_777's avatar
        abc_777
        Solution Specialist
        1 year ago

        Hello Greg_Deckler ,

         

        thanks man, this is the one i was looking for. when create vedio clip request u please share me.

         

        i just have a little quiry rather make 

        Measure = 20000000
        Measure 2 = IF( [MOM] > 0, 20000000 )
        Measure 3 = IF( [MOM] < 0, 20000000 )  static,  cant we make them dynamic?
         
        and i dont see the use of followings
        MOM Neg = IF( [MOM] < 0, [MOM], BLANK() )
        MOM Pos = IF( [MOM] > 0, [MOM], BLANK() )
         
        would you mind to help me out please
         

         



        thanks