Line and Clustered Column Chart different line level

[Harry_Tran]

Hello everyone,

I have a Line and Clustered Line Chart line this

I would like add -20% Benchmark and 100 Benchmark to this visual.

-20% Benchmark = -0.2 and 100 Benchmark = 100.

The -20% is for the line values and 100 Benchmark is for Column values.

The issue that I have is the Benchmarks have different value and they are used to compare different things too. So, when I try to add the Benchmarks to the visual it would be like this

What i am trying to do is creating 100 Benchmark to compare with column value and -20% Benchmark to compare with line value.

Thank you!

[APavlovs]

@Harry_Tran 

It`s a paid visual, but You can try to use Drill Down Combo Pro visual to achieve the wanted result - https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381944?tab=Overview

This visual allows you to have multiple series (values) displayed on the visual and you can customize each series individually.

So you can adjust any of them to be either a Column, Line or Area. Same goes also for Value axis used. So you can just mix and match the series.

[Calvin69]

Hi @Harry_Tran ,

I think without have a quick look at the file it would be difficult to answer this.

This might be totally irrelevant but worth a quick read:

https://community.powerbi.com/t5/Desktop/Line-and-Clustered-Column-Chart-Unable-to-always-show-1-Y-a...

Also, did you try different formatting options for that visual or perhaps exploring some additional visuals from the online market?

H