Forum Discussion
Line and Clustered Column Chart different line level
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!
2 Replies
- Calvin69
Helper III
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:
Also, did you try different formatting options for that visual or perhaps exploring some additional visuals from the online market?
H
- APavlovs
Resolver II
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.