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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Nogstai
Helper I
Helper I

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 @Nogstai,

 

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 @Nogstai,

 

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.

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

amitchandak
Super User
Super User

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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