Matrix visual help

[vivek_babu]

Hi,

I am looking to replicate the below visual in Power BI using matrix visual. The challenge here is that the Systems column which contains Total Systems, Windows, Mac, Linux and Android all are count of those column names. I have yearmonth column which will be used in column section of matrix. How to replicate the below format in matrix visual in power bi?

Sample Image:

@lbendlin @shafiz_p @Kedar_Pande @Bibiano_Geraldo @Anonymous @Anonymous @rajendraongole1 @Jai-Rathinavel @danextian @carlosbarboza @johnt75 @Ritaf1983 @DataNinja777 @FreemanZ @Greg_Deckler 

Thank You

Regards

Vivek N

[FreemanZ · Accepted solution]

hi @vivek_babu ,

try to pull month as column and system as row, any column from the same talbe to the value field and choose count.

what is special here?

[shafiz_p · Accepted solution]

Hi @vivek_babu  Turn on Switch Values to rows and move year-month to column. 

This is normal in matrix:

After applied above mentioned step, output is :

Hope this helps!!

If this solved your problem, please accept it as a solution and a Kudos!!

Best Regards,
Shahariar Hafiz

[shafiz_p · Accepted solution]

No option to write row header. This will be empty. You can use Text box to write header.

[vivek_babu]

Hi @FreemanZ ,

I just missed the switch values to rows so it was not coming properly 

Regards

Vivek N

[shafiz_p · Accepted solution]

Hi @vivek_babu  Turn on Switch Values to rows and move year-month to column. 

This is normal in matrix:

After applied above mentioned step, output is :

Hope this helps!!

If this solved your problem, please accept it as a solution and a Kudos!!

Best Regards,
Shahariar Hafiz

[vivek_babu]

Hi @shafiz_p 

Thanks for providing the solution. Everything looks good just i want to add the header for the rows? How to do that? It is empty now i want to name it as systems?

Regards

Vivek N

[MockIT2As]

Reply to all Engagement in Mock IT Assessment- Group 2.

[FreemanZ · Accepted solution]

hi @vivek_babu ,

it can also be added as visual title

[vivek_babu]

Thank you i added as visual title Regards Vivek N

[shafiz_p · Accepted solution]

No option to write row header. This will be empty. You can use Text box to write header.

[vivek_babu]

Thank You

[FreemanZ · Accepted solution]

hi @vivek_babu ,

try to pull month as column and system as row, any column from the same talbe to the value field and choose count.

what is special here?