To have child hierarchy for values in matrix

[Vidyashree]

Hi All,

Below is my Table structure Table Structure

 and I want something like below in my matrix

My requirement in matrix

 Is it feasible in Power BI?

Please help!!

Thanks in advance!! 🙂

[v-danhe-msft]

Hi @Vidyashree,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft]

Hi @Vidyashree,

Based on my test, you could refer to below steps:

Unpivot the [Subject-1 Score] column and [Subject-2 Score] column.

Before unpivot

After unpivot

Apply it and create a matrix visual and now you could see the result.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/cv0scuwjvrw4m52/To%20have%20child%20hierarchy%20for%20values%20in%20matrix...

Regards,

Daniel He

[Vidyashree]

Thanks for your reply. 🙂

Yes, I did the same. But the problem is "Subject 2 Score" is in Percentage and when I add few more columns to Row like "Department"  it sums up when drilled up, which is incorrect. I cannot define the "Attibute" as Percentage Type as "Subject 1 Score" is numeric value. I want

1. "Subject 1 score" as numerical value, 

2. "Subject 2 score" to show as percentage 

 when another column "Department " is added at Row header. 

Is there a way to define "Subject 1 Score " as Numerical Data type and "Subject 2 Score " as Percentage Type after unpivoting?

[venug20]

Hi Vidya,

1. you should maintain Subject-2 marks in different formate

2. when place values in power bi matrix visual, you should select "Fields - Subject2-scor" and "Matrix visusal - Subject2-Scor" then you click on percentage from model..

finally output come like below

[v-danhe-msft]

Hi @Vidyashree,

Based on my test, I am afraid you could not chang the customer value as percentage, if you want to show the percentage, you could just make the whole value as percentage.

Regards,

Daniel He