Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

 

 

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

Below is the snip --

 

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

 

Please suggest how we can achieve this in Power BI.

Thanks,

 

Need Help
Tips and Tricks

3 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

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

     

  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    Icon for Super User rankSuper User
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HI Anonymous,

    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