How to create a grouped column and line chart under this circumstances

[Anonymous]

Hello everyone!

I was trying to make a chart like this one (data labels are not required they are there just so the chart is easier to understand):

After filtering the data with filtering visual objects I can get a set of data like the following:

bars [230, 150, 90]

upper red line [210,210,210]

downer red line [90, 90, 90]

black line percentages [0.5, 0.3, 0.2]

As you can see, columns and red lines use the left Y-axis to represent their values while the black one use the right one, is this achievable by using this tool?:

  Because I haven't been able to reproduce it and this is what I get because all lines use the right Y-axis: 

Thanks before hand,

Yours faithfully,

Zaloon.

[radhey_rec · Accepted solution]

Hi @Anonymous ,

If you can use custom visuals, you can develop this visual in https://pbivizedit.com

I am able to produce following visual by the data you have give:

Please try and feel free to contact their support if you find it difficult to reproduce this visual.

Thanks,

-R

[Anonymous]

Thanks for the advice, let me try and I'll accept your solution later.

[amitchandak]

@Anonymous , You can have three lines two lines can be the constant measure

upper =210

lower =90

Enable label only for one line and bar

[Anonymous]

The problem is that I can't get the red lines to use the values of the left Y-axis they use the right one, the secondary axis that is used by default. And the lines values vary depending on the filtered data so I can't make them constant.