Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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))
Thank you for the solution but i need this thing in 100% stacked column chart. If you have any idea.
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.
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |