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
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
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Bibiano_Geraldo
Resolver I
Resolver I

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.

 

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.