Show repeating rows in Matrix Visual without stepped layout and fully expanded

[Anonymous]

Hello,

as a newby i'm trying to create a matrix visual that displays one measure (count of packages per year) for article and supplier dimension data.

If I use a normal table visual the data is displayed like this:

Article No | Supplier |  Year | Count of Packages

1234            XXXX       2022     10

1234            YYYY       2023     10

1234            ZZZZ       2023     30

The requested output is like this:

Article No | Supplier |  Count of Packages 2022   | Count of Packages 2023  

1234            XXXX                    10                                       0

1234            YYYY                     10                                       0

1234            ZZZZ                      0                                       30

So I changed to the matrix visual, turned off stepped layout, expand the hierarchy to the lowest level and disabled the arrow icons.

Unfortunateley the result  is as follows:

Article No | Supplier |  Count of Packages 2022   | Count of Packages 2023  

1234            XXXX                    10                                       0

                    YYYY                     10                                       0

                    ZZZZ                      0                                       30

So, my question is, if and how it's possible to display the article no. 1234 in this example in each row.

Since the main purpose will be an excel export at the end, maybe it's possible to do it in the PBI Service Excel Export, but i didn't find an option. A CSV-Export will create a csv like in the first table, without pivoting, only raw data with one row for each years Package count. In PBI Service, if I choose, "data with current layout", i get the table 1:1 like in the visual.

The issue for the requester is, that it's necessary to get an Excel-Result with filter options. It's not possible to filter, if there are empty cells for an article.

Thanks a lot in advance 🙂

[Anonymous · Accepted solution]

Hi @Anonymous ,

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Pivot the column "Year"

2. Create a table visual

Best Regards

[Anonymous]

Hi,

yes, for me this is a workarround, thank you.

I solved it in the same way.

But my question is: So, there is no option to steer the matrix visual in order to let it display repeating values?

[Anonymous · Accepted solution]

Hi @Anonymous ,

Base on my research, there is no option or settings can achieve the similar requirement. You can consider to submit a new idea. It is a place for customers provide feedback about Microsoft Office products . What's more, if feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards

[Anonymous]

Hi,

ok, got it.

Anyway thank you for your support.

PS: In Micro Strategy there is a simple Button for turning on and off merging row headers, so you have the repeating values displayed in the report. Wondering, if i'm the first person missing that option in PBI 😉

[Anonymous · Accepted solution]

Hi @Anonymous ,

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Pivot the column "Year"

2. Create a table visual

Best Regards