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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MeiYing
Helper I
Helper I

Not to display 'Total' under column headers in Matrix

Hi experts, 

 

I am still new to the Power BI. Is there any workaround to remove 'Total' display under headers of the matrix? What I am trying to do is whole matrix will stay hidden until user click any column in bar chart. But the top part of the matrix (shown in screenshot) is always there and I have to use card to cover it up. The card moves behind and values in matrix appear when user make selection in bar chart, but the problem is I cannot click the 1st row because it is cover up by the card. So, I am thinking if I can remove 'Total' display I only have to cover up the headers and I would be able to click the 1st row. I followed this tutorial https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/

MeiYing_0-1680775499643.png

 

2 REPLIES 2
MeiYing
Helper I
Helper I

Hi,

Thanks for the reply. Yes, I tried to tick that off but I still want 'Total' to display at the bottom of the matrix. The problem is I don't want it to be there when there is no data (as shown in screenshot). I am not sure if that is possible.

olgad
Super User
Super User

hi, have you tried to tick off row subtotals?

olgad_0-1680776796397.pngolgad_1-1680776810884.png

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.