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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.