Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
Does anyone know how I could show investment performance in a matrix visual, which displays the original source data for all rows in a hierarchy? The 1st screenshot below is how I'd like the data to appear, but the second screenshot is how it appears. The data should not be summed. I've tried drilling down to a different level in the hierarchy, which changes the data displayed, but it doesn't resolve the summing issue. I just want to show the same data that are in the data source but in a nice Power BI matrix visual.
Any help would be much appreciated!
Thanks.
1st screenshot:
2nd screenshot:
Could you share a sample pbix with dummy data?Maybe it can be solved by isinscope function.
Hi @KevinGraham
Watch this video it might help you out
https://www.youtube.com/watch?v=DGPvGqzQteM
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 65 | |
| 44 | |
| 40 | |
| 29 | |
| 19 |
| User | Count |
|---|---|
| 200 | |
| 130 | |
| 102 | |
| 72 | |
| 55 |