Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ltsh
New Member

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).

 
 
 

1.PNG

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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 @Motasem_Yakhola 

 

Because I want Sub region, country, population and percentage in same line.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors