BI TABLE+MATRIX

[BatuhanUlu]

Hello All,

To minimize my efforts after anaylzing the power bi report, i need a table as below in power bi,

Columns with blue background is a matrix which has Material as rows, Brands as columns and Prices as values.
Columns with yellow background is a table which has shown fields as columns.
(If you're color-blind, first 5 columns are yellow, rest is blue)

I don't know how to have this kind of structure in power bi, i wanted to create another table which would have a column for every brand but it turned out to be very static, not getting updated when i add a new brand.

I'd really appreciate any idea, thanks in advance 😄

For further contact: batuhanulu01@gmail.com

[Bmejia · Accepted solution]

Hi BatuhanUlu,
I think having a sample of the data structure would be helpful (table(s)) but this is a way that you can get it complete.  I am assuming your data is structure some what similar to the attached sample. 

[BatuhanUlu]

Dear Bmeija,

Thank you for your efforts and reply. I didn't know that i could use the matrix like that because it displayed the data within hierarcy always. Could you kindly describe me of how to remove these minus icons from the matrix?

I'm having these minus icons in matrix table whereas you don't have them in 2024 sales and min brand price columns (additional rows to material in matrix).

[Bmejia]

select table and go to row header to remove+/-

[BatuhanUlu]

Thank you again Bmejia 😊