Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
how to get +ve & -ve value at the top of the X axis Bar
after substracting 2 measure values check the attached pictures
Hi @nra12 ,
You can try formula like below:
M_ =
VAR next_ =
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER ( ALL ( 'Table' ), 'Table'[Date] >= MAX ( 'Table'[Date] )-1 )
)
var cur = MAX('Table'[Value])
RETURN
CALCULATE (
MAX ( 'Table'[Value] ),
FILTER ( ALL ( 'Table' ), 'Table'[Date] = next_ )
) -cur
If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey henryK thankyou for the response but the suggested one is not working as i want in visual " line clustered/Stack chart"
User | Count |
---|---|
87 | |
84 | |
67 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
84 | |
70 |