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

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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
1 year ago

abc_777 Yeah, I made them dynamic in the video. And I don't use those measures actually, they were artifacts from messing around trying different things. Here's the video link: