Custom line and column chart with 2 axis, and 2 different formats of values on the line axis.

[zenisekd]

Hi everybody, 

Could somebody advise me on how to create a chart, probably custom, which would look like in the picture bellow?

The problem is, that PBI doesnt allow user to put two different format values into lines of combined column and line chart (% and Kč in my case). 

I also cant use constant (even if it was allowed in the combined chart), because the target is dynamic, based on the market slicer. 

I know, that there is a custom on the marketplace chart, which is however paid ... I tried to create the chart via power bi tips, but that didnt work well. It is easy to create in Excel, however, I am stocked with Power BI...

[v-lionel-msft]

Hi @zenisekd ,

Do you mean that the unit of target line and polyline cannot be set separately?

Yes, the current version is impossible to do this.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lionel-msft]

Hi @zenisekd ,

Is it like this? We can make the values of the two axes in different units.

My Power BI Desktop vsersion: 2.91.701.0 64-bit (March 2021)

What's your version? Please update to the latest version.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[zenisekd]

Hi Lionel, 

What you did is my current state, I am however still missing the line with target.

Best regards 

David