Repeating Values on a Matrix/Table Visual

[mm8718]

Hi All

First post here and fairly basic user in PowerBI. I am trying to create a report that is needs to show top level figures as well as the detail below it. Ideally this table/matrix

Is there a way to remove the repeating lines against the Columns? In the example below, i only want the detail under column 3 for example and the rest can just be totalled or summarised in a top line.

The data is linked through external data sources so cant really play with it too much

I can understand why it is doing it but i would rather it did not. Some columns i would need the detail figures but on others just a summary will do. We can easily remove it in Excel but a ready made option will be better!

[PaulDBrown]

You can use measures with ISINSCOPE. Let's say the detail level row is Table[Detail]. 
create the measures following this logic:

Remove detail sales = IF(ISINSCOPE(Table[Detail]), BLANK(), [Sales Measure])

[v-yanjiang-msft]

Hi @mm8718 ,

According to your description, if you just donn't want to show the blank rows in the column3, you can unselect the Blank value in the visual filter.

If I misunderstanding your purpose, please feel free to let me know.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

[davehus]

Hi @mm8718 , The simplest way I can think of is to apply a conditonal format to the columns you don't want the line level it. I'd a similar need before and this worked a treat for me.

Sample link on conditional formatting if you haven't used it before  >https://www.mssqltips.com/sqlservertip/6265/power-bi-conditional-formatting-for-matrix-and-table-vis...

Please accept my solution if it meets your needs.