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

Thejeswar's avatar
Thejeswar
Super User
1 year ago

Hi abc_777 ,
We can create a similar chart with your data too. But the showing of markers with different colours needs conditional formatting. But unfortunately I am not seeing option to perform Conditional formatting in the Power BI version that I am using. 

 

To note, Conditional formatting cannot be done directly to Line charts but there is a workaround we do with bar charts. But even that doesn't seem to be available for me. Not sure if this is after the recent update (I am using Power BI Jan 2025 version)

 

If you are not aware about conditional formatting, 

Conditional Format a line chart in Power BI

 

If you want to know how you can set up error bars

How To Add Error Bars in PowerBI - The Data School

 

Regards,

abc_777's avatar
abc_777
Solution Specialist
1 year ago

can u share the sample pbi file please?