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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Can visuals show total instead of % of total? if so, how?

I have a question for visuals within a report.

 

I have this report that includes a matrix and a couple of graphs. (Redacting details as it's not needed)

Nogstai_4-1651246706595.png

 

Whenever I click on the users, I get only the percentage within the graphs.

 

Nogstai_1-1651246519051.png

 

Is it possible, that instead of the percentage of the totals, I get the graphs like this:

 

Nogstai_2-1651246614014.png

I used a slicer to get this result. I was thinking if it was possible of doing it without a slicer and just on the matrix table.

 

1 ACCEPTED SOLUTION
v-chenwuz-msft
Community Support
Community Support

Hi @Anonymous,

 

You can try Edit interactions. Change Highlight to Filter.

vchenwuzmsft_1-1651654796059.png

Please refer this article.

Change how visuals interact in a report - Power BI | Microsoft Docs

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-chenwuz-msft
Community Support
Community Support

Hi @Anonymous,

 

You can try Edit interactions. Change Highlight to Filter.

vchenwuzmsft_1-1651654796059.png

Please refer this article.

Change how visuals interact in a report - Power BI | Microsoft Docs

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

This was the solution I was looking for! Thank you!

amitchandak
Super User
Super User

@Anonymous , I doubt you can show actual %, unless he pie is made on percent

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 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.

Top Solution Authors