Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
KevinGraham
Helper I
Helper I

Matrix visual - show data source values instead of summing

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:

KevinGraham_0-1630615505058.png

2nd screenshot:

KevinGraham_1-1630615632352.png

 

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

Could you share a sample pbix with dummy data?Maybe it can be solved by isinscope function.

aj1973
Community Champion
Community Champion

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.