Forum Discussion
Solved
Percentage difference on total
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
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:
3 Replies
You can create a new measure:
% Diff = (TY -PY) / PYThen you can format it and add it to your matrix visual.
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:
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
