add a reference line to stacked column and line chart

[Anonymous]

Hey everyone, 

I am struggleing to get a visual to work and looking for some advise. 

I have the above graph with % on the columns and total number on the line

I want to be able to add a constant line at 95% as a goal line like I can do in a regular column chart

can this be done?

[v-kelly-msft]

Hi  @Anonymous ,

Create a measure as below:

Measure = 0.95

Make it show as percentage,then go to format>Y axis>show secondary : on, align zeros : on:

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

hey @v-kelly-msft 

that doesn't work, I'm trying to show a % month over month vs a % goal (constanat line or measure) vs the total contact volume in a number format

here's some dummy data

here is what I'm looking to make in pbi, this was made in Tableau since I have loads more experience with that tool.  the bars are the total volume, the line is the % capture rate, and the dotted line is the goal

[v-kelly-msft]

Hi  @Anonymous ,

Is below what you need?

If so,create a line and stacked column chart,mark format setting as below:

Go to format>Y axis,under show secondary>start:0,

For details,pls check the .pbix file attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

@amitchandak here is the issue, it doesn't work becuase it want's to compare the 95% to the right axis which is in numbers. 95% shown below in the dark blue line.

[amitchandak]

@Anonymous , Create a measure like

Measure = .95

and mark that as % in Measure Tools.  and add that to visual