Repeat all item labels in matrix

[JohannesM]

Hi,

Can I (like in Excel) somehow repeat all item labels in a matrix visual. Illustrated in red below 😉

Br

Johannes

[MorrisBI]

Hello

Now, with may update you can do this.

Here the step:

1.- Visual tab

2.- Layer and style presets

3.- Layout (Open, dropdown list)

4.- Select your style, the combination that you are looking for is Outline and below, repeat lines.

This is only in Matrix Visual.

Here a youtube video, min 00:32

https://youtu.be/ktMr3RebZgA?si=Ae-1Qvy61chKnk2T&t=32

[vishu263]

Hello @JohannesM , 

By now, you must be knowing that achieving this output in Matrix visual in Power BI is not possible.

In fact I faced the same problem and here is the workaround which I hope would help you as well.

1) convert this Matrix into a 'Table' visual.

2) Keep only 3 columns in it. In your case, it will be Konto, Motpart, Nat.

    Remove the date column & also remove the meaure.

3) Create a DAX Measure to calculate the value based on the date column. for e.g. 

Revenue202102=CALCULATE(SUM('CSR'[Revised Revenue]),'CSMT'[Fiscal Period]=2)

You need to create multiple measures here depending on the years you want to show into a table. (I created 12 as there were total 12 Fiscal Period in my case.

4) Now add there measures side by side in your table. It will look exactly the same way as your Matrix with repeated values in each row.

Below is the snapshot of Before & After view of my report for your reference.

Thanks.

[Anonymous]

Hi @JohannesM ,

Base on my research, there is no option setting or feature can repeat these rows in matrix. 

How do I repeat row values in a matrix?

The following link is a similar idea shared on Power BI Ideas , you can vote it up and add your comments there to improve Power BI on this feature. 

matrix repeat rows

Best Regards

[amitchandak]

@JohannesM , You have to use a table visual for that, if possible. I doubt that is possible in Matrix

[JohannesM]

Hi,
Thanks for your reply but that would defeat the purpose since I then get one kolumn for all periods instead of one kolumn for each. This woud result in alot of rows and it to unreadable by the user =(