Forum Discussion
Create different grouped rows in a Matrix Visual
Yes, that's correct. You can't directly add the region grouping as rows below the matrix visual. However, you can use measures to calculate the overall sales for each region and then add those measures to the matrix visual as value fields. This will achieve a similar effect to having the region grouping as rows below the matrix.
Here's an example of how you can create a measure to calculate the overall sales for the North America region:
Sales in North America overall =
SUMMARIZE(
'Table',
'Table'[Sales Target],
"Region", "North America"
)To create measures for the other regions, you can use a similar formula and just replace "North America" with the name of the desired region.
Sales in South America overall =
SUMMARIZE(
'Table',
'Table'[Sales Target],
"Region", "South America"
)Sales in Europe overall =
SUMMARIZE(
'Table',
'Table'[Sales Target],
"Region", "Europe"
)Sales in Asia overall =
SUMMARIZE(
'Table',
'Table'[Sales Target],
"Region", "Asia"
)Then, you can add these measures to the matrix visual as value fields and they will show the overall sales for each region.
I hope this helps!
Yes, it is possible to create the desired matrix visual in Power BI.
Create a new column in your data table called "Region" and assign each country to a region (e.g. USA and Canada belong to North America).
In Power BI, add the "Region" column to your matrix visual as a row field.
Right-click on the "Region" row field and select "Add Total" > "After". This will add a row at the bottom of the matrix visual that shows the overall sales for each region.
To show the overall sales for all countries, add a row field for the "Country" column and then right-click on the "Country" row field and select "Add Total" > "After". This will add another row at the bottom of the matrix visual that shows the overall sales for all countries.
To show the overall sales for each region, you can use the SUMMARIZE function to create a measure that sums up the sales for each region. For example: Sales in North America overall = SUMMARIZE( 'Table', 'Table'[Sales Target], "Region", "North America" )
Add this measure to the matrix visual as a value field and it will show the overall sales for each region. You can create similar measures for the other regions as well.
I hope this helps! Let me know if you have any questions.
Thanks for the fast reply. So this means I'm not able to directly add the region grouping as rows below the matrix visual?