To add a constant line for different values present in a slicer

[Anonymous]

    I have a slicer in which there are two values. I want to add the same constant line for other value in the slicer. So that now it is at 80%. If i select another value in filter it shows 85%. Thanks. 

[v-frfei-msft]

Hi @Anonymous ,

We can use Line and stacked column chart to work around. Here we should create two measures as below.

Measure 2 = var b = CALCULATE(SUM('Table'[per]),ALLEXCEPT('Table','Table'[name]))
var a = SUM('Table'[per])
return
DIVIDE(a,b)

Measure 3 = var sele = SELECTEDVALUE(slicer[slicer])
return
IF(ISBLANK(sele),BLANK(),IF(sele="a",0.8,0.85))

[Anonymous]

Thank you for the solution but i need this thing in 100% stacked column chart. If you have any idea. 

[v-frfei-msft]

Hi @Anonymous ,

Based on my research, it is not supported yet currently to add a measure in Constant trend line. There is an idea about that you can vote it up to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33490639-constant-trend-line-as-a-measure