Forum Discussion

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

PianoChart.pbix41 KB
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

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.

PianoChart.pbix41 KB

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