Forum Discussion
Matrix - not show data in total row
Hi everyone,
I have population data. it contains detail like Region, Sub region, Country, 2020 population, 2019 population and others. I want to use matrix control so I can show the values like following snap. When I pull country from Rows to "Value" section of matrix, it is showing me with the first country in total rows. But I want to not show the first country in total rows and show sum of 2020 population, 2019 population, and percantage only (I want to not show country as yellow text bar).
Hi Ltsh,
Please refer to the following blogs to know how to find out the specific hierarchy level of row contents, you can add filter to check the current level and replace the specific level of blank to ignore the total level value displayed.
Clever Hierarchy Handling in DAX
Use IsInScope to get the right hierarchy level in DAX
In addition, the simplest way is doing 'subtotal'/'grand total' settings on format panel, you can accurately control which field total displayed.
Create matrix visualizations in Power BI#subtotals-and-grand-totals-with-matrix-visuals
Regards,
Xiaoxin Sheng
3 Replies
- Motasem_Yakhola
Helper I
Hello Ltsh,
Why you are putting countries on values; instead of putting it on rows or columns to get the data of all countries in each region?
Looking for more clarification in order to help you.
Best wishes.
----------------------------------------------
Did I answer your question? Mark my post as a solution!
Don't forget to like my post please.
Hi Ltsh,
Please refer to the following blogs to know how to find out the specific hierarchy level of row contents, you can add filter to check the current level and replace the specific level of blank to ignore the total level value displayed.
Clever Hierarchy Handling in DAX
Use IsInScope to get the right hierarchy level in DAX
In addition, the simplest way is doing 'subtotal'/'grand total' settings on format panel, you can accurately control which field total displayed.
Create matrix visualizations in Power BI#subtotals-and-grand-totals-with-matrix-visuals
Regards,
Xiaoxin Sheng
