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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Visual report editing

Dear All,

 

in this report, the highlighted no "1", how can i remove the number "45" from the list of products and just show the total at the bottom? And the highlighted no "2", how can i remove the total number at the bottom?  Please advise. Thanks

Yau0101_0-1634709563153.png

 

1 REPLY 1
Samarth_18
Community Champion
Community Champion

Hi @Anonymous 

 

There is no straight forward way to do it. So we just need to do some work around.

 

For your 2nd question you can change your total value color same as background, to do that you can follow below steps:-

1. Go to field formatting option

Samarth_18_0-1634712603659.png

2. Now select your column count of no of quotes issue from the drop down and change the font color same as your total background color.

3. And enable Apply to total option

Samarth_18_1-1634712788491.png

 

You can follow the same steps for your 1st questions as well by changing background color and font color as white but enable Apply to Values option only .

 

Thanks,

Samarth

 

 

 

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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