The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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
User | Count |
---|---|
65 | |
60 | |
55 | |
54 | |
31 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
46 |