Add constant line in combo chart

[Anonymous]

Hi All,

I want to add a constant line on Line and Column Combo chart similar to dashed line at 100%. Rest i am able to create except for this line.

 

Your help will be really appreciated.

Cheers

Shruti

[Anonymous · Accepted solution]

I have worked out the way to add a constant line in combo chart by using a measure and set it as a percentage. 

[v-yulgu-msft]

Hi @Anonymous,

You could create a measure which returns the corresponding value of that dashed line. Add the measure to "Line Values" section in chart visual.

Regards,

Yuliana Gu

[Anonymous]

@v-yulgu-msft 

I tried creating a measure but it didn't work well.