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. 221...
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:
You can create a new measure:
% Diff = (TY -PY) / PY
Then you can format it and add it to your matrix visual.