hi

[abc_777]

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

[Greg_Deckler · Accepted solution]

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

[Greg_Deckler]

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

[abc_777]

Hello @Greg_Deckler ,

https://www.linkedin.com/posts/arttennick_powerbi-activity-7282525744604299266-C1qK

here it is

[Greg_Deckler · Accepted solution]

@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 · Accepted solution]

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]

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

[Thejeswar]

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]

@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

Year	Month	Item name	Item Quantity
2023	January	A	2
2023	February	b	4
2023	March	c	2
2023	April	a	3
2023	May	b	4
2023	June	d	5
2024	July	b	6
2024	August	a	4
2024	September	c	3
2024	October	a	2
2024	November	b	4
2024	December	e	3

thanks

[Thejeswar]

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]

can u share the sample pbi file please?

[abc_777]

Hello @Thejeswar 

Not an issue at all. 

Lets first create a piano chart. then we can use conditional formating. i will check as well in mean time u can give a try with this latest power bi version. hope we can make that. work. 

would be greeatefull if u share pbi file 

thanks for your time and help man

[abc_777]

no luck?