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

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

Reply
Anil_katta
Frequent Visitor

Hide Group header in matrix visual

Data Groups ---

We are grouping states with name Omni - with in Omni we are again grouping Offline and Online states.

Anil_katta_1-1705731989997.png

 

Anil_katta_0-1705731940198.png

 

We have an Matrix visual with in that  for Rows - we are using State (groups) (groups), State (groups), State.

Below is the snip --

Anil_katta_2-1705732641198.png

 

Here, we have to hide first two rows i,e. Omni and Offline.

 

Please suggest how we can achieve this in Power BI.

Thanks,

 

3 REPLIES 3
Anonymous
Not applicable

HI @Anil_katta,

For power bi visuals, they will auto hide the row/column which not existed correspond values. Since these two rows are the subtotal level, they will auto summary the child level values, so they are not suitable for auto hide features.

BTW, I also think it is impossible to directly hide or custom on these category fields.

Regards,

Xiaoxin Sheng

Bibiano_Geraldo
Super User
Super User

Select the matrix, go to the filter panel, make sure your state (groups) (groups) is there, in basic filtering uncheck your desired values

Ritaf1983
Super User
Super User

Hi @Anil_katta 
The question is unclear, please share a link to pbix with a dummy example and show the desired result.

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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