Forum Discussion
Repeating Values on a Matrix/Table Visual
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!
3 Replies
Hi Anonymous , 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-visuals/
Please accept my solution if it meets your needs.
Hi Anonymous ,
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 _ kalyjIf this post helps, then please considerAccept it as the solution to help the other members find it more quickly.
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])
