Matrix Visual

[Mario_Jo]

Hi Folks,

How can I create table visual like this. I don't know if power bi have visual like this.

[v-prasare]

Hi @Mario_Jo,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

[pankajnamekar25]

Can you share picture

If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


Thanks,


Connect with me on:

LinkedIn

[Natarajan_M]

Hi @Mario_Jo , You can acheive this using the field params . 
I have recreated the scenario you shared .

Data Model :

Measures :

Total Revenue = SUM( Sales[Revenue] )
Total Quantity = SUM( Sales[Quantity] )
Order Count = DISTINCTCOUNT( Sales[OrderID] )
Avg Order Value = DIVIDE( [Total Revenue], [Order Count], 0 )
Avg Discount = AVERAGE( Sales[Discount] )

Modelling -> new parameter -> field parameter -> give name -> choosea dimension column -> now you can see a new table in your canvas 

Dimension Selector :

Dimension Selector = {
("Product", NAMEOF( Products[ProductName] ), 0),
("Category", NAMEOF( Products[Category] ), 1),
("Customer", NAMEOF( Customers[CustomerName] ),2),
("Segment", NAMEOF( Customers[Segment] ), 3),
("City", NAMEOF( Customers[City] ), 4),
("Region", NAMEOF( Regions[RegionName] ), 5)
}

Measure Selector :

Measure Selector = {
("Revenue", NAMEOF( [Total Revenue] ), 0),
("Quantity", NAMEOF( [Total Quantity] ), 1),
("Orders", NAMEOF( [Order Count] ), 2),
("Avg Order Value",NAMEOF( [Avg Order Value] ), 3),
("Avg Discount", NAMEOF( [Avg Discount] ), 4)
}

Product and category :

product category and customer :

PBIX: Selecting Kpis.pbix

Thanks 
If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster

[MFelix]

Hi @Mario_Jo ,

What is the purpose of the highlited column, no sure if I have translate it correctly so if you can explain what you want to obtain it woudl be helpfull.

[Mario_Jo]

I want to create table visual like the screenshot. So. So the dimension will be on middle and if user selected 2 dimension it will be add new colunmn on right side