Percentage difference on total

[RDF25087]

Hi all -

I have built a matrix in Power BI and want to show a percentage difference between the values by row PY vs TY:

So it looks something like:

2023	2024	Total	% Diff.
22119	19488	41607	-11.89%
10809	8237	19046	-23.79%
1857	2147	4004	15.62%
34785	29872	64657	-14.12%

Thanks

RDF

[Darui6]

You can create a new measure:

% Diff = (TY -PY) / PY

Then you can format it and add it to your matrix visual.

[bhanu_gautam]

@RDF25087 , Use DAX to create new measure

% Diff. =
VAR PY = SUM('YourTable'[PY])
VAR TY = SUM('YourTable'[TY])
RETURN
DIVIDE(TY - PY, PY, 0) * 100

[danextian · Accepted solution]

Hi @RDF25087 

You will need a disconnected table and some measures to achieve your use case like below:

Sample pbix is on the video description:

https://youtu.be/UMz-X-l0_jQ?si=slcTkWzuFJVe025E