Forum Discussion
Matrix visual help
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
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?
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 HafizNo option to write row header. This will be empty. You can use Text box to write header.
9 Replies
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?
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 HafizHi 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
No option to write row header. This will be empty. You can use Text box to write header.
