cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Matrix Visualization: Hide Subtotals with a Blank Description

My data set it is using a hiarchal structure that does not require a value in each level of the hiarchy.  This causes several subtotal line to appear as blank lines in the matrix and add extra subtotals that arn't needed. Is there any way to hide subtotal rows with a blank description.

 

Here is a sample of the output.2019-01-23_11-00-01.jpg

 

 

 

4 REPLIES 4
v-piga-msft Resident Rockstar
Resident Rockstar

Re: Matrix Visualization: Hide Subtotals with a Blank Description

Hi @Anonymous,

 

By my tests, if you set the value like below in visual level filter then you could achieve your desired output.

 

matrix.png

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Matrix Visualization: Hide Subtotals with a Blank Description

Thank you for your reply Cherry, This solution doesn't really work for my issue.

In my data set I don't have any lines with 0 values, but I do have lines with missing values in L3, L4, and L5 header.  Here is a sample of what the data looks like:

 

2019-01-24_10-44-57.jpg

 

The problem comes in because not ever line has a value for L3, L4, L5, but some do. Since I'm grouping the rows by that field it will used the blank value in there and treat it as if there was a value.

v-piga-msft Resident Rockstar
Resident Rockstar

Re: Matrix Visualization: Hide Subtotals with a Blank Description

Hi @Anonymous,

 

If I understand your requirement correctly that you want to hide the rows highlight in red?

 

remove the row highlight in red.png

 

If it is, you could use the solution I mentioned for the first reply, may be you could try is not blank.

 

is not blank.PNG

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Matrix Visualization: Hide Subtotals with a Blank Description

Not quite, I'm tying to hide the following lines outlined in red.

2019-01-23_11-00-012.jpg

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors