Forum Discussion
hi
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.
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 = 20000000Measure 2 = IF( [MOM] > 0, 20000000 )Measure 3 = IF( [MOM] < 0, 20000000 ) static, cant we make them dynamic?and i dont see the use of followingsMOM Neg = IF( [MOM] < 0, [MOM], BLANK() )MOM Pos = IF( [MOM] > 0, [MOM], BLANK() )would you mind to help me out please
thanks
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,
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
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,
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
can u share the sample pbi file please?