Add a second header in matrix PBI with no hierarchy defined

Hi Anonymous,

 

For doing this you have currently two options.

 

Field parameters

In this case  you can create a field parameter table (see link) then on this table add a column with the category you need to group by and you can then use that on your matrix.

 

Disconnected table

This is similar to the other option however you need to build the table manually so you would get something similar to this:

Group	Measure	ID
Total Sales	Total_Sales_Wheels	1
Total Sales	Total_Sales_Engines	2
Total Costs	Total_Costs_Wheels	3
Total Costs	Total_Costs_Engines	4

 

Now you just need to create a metric similar to the one below:

Matrix value =
SWITCH (
    SELECTEDVALUE ( Table[ID] ),
    1, [Total_Sales_Wheels],
    2, [Total_Sales_Engines],
    3, [Total_Costs_Wheels],
    4, [Total_Costs_Engines]
)

 

Now use this metric on the matrix visualization.