Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |