topic Re: Matrix visual show in Custom Visuals Development Discussion

Matrix visual show

tructran — Wed, 11 Sep 2024 07:10:47 GMT

I have an excel file with picture below. I want to build the matrix visual and color row header with condition formating. Can you help me? Thanks all

Re: Matrix visual show

uzuntasgokberk — Mon, 14 Jul 2025 20:06:11 GMT

Hello tructran,

İf you are using matrix in Power BI. You make conditional formatting only values section.

But if you can use tables visualization you make conditional formating every column.

For row header or column header in matrix there is no conditional formatting.

Re: Matrix visual show

tructran — Wed, 11 Sep 2024 07:29:19 GMT

So, do you know how to use R visual to show this matrix table because i can't not use table visual for row and colum like photo below!

Re: Matrix visual show

uzuntasgokberk — Mon, 14 Jul 2025 20:06:59 GMT

Hello tructran,

You can do that within Power BI without using R. For example you would to give color conditional in the colum header. There is a statical option in column header color. Also, I don't know R and there are some limitation in R.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-r-visuals

Re: Matrix visual show

tructran — Wed, 11 Sep 2024 07:47:26 GMT

I mean that how to I can show columns with value in excel, if you don't use matrix visual. After all., thanks for your helps!

Re: Matrix visual show

uzuntasgokberk — Mon, 14 Jul 2025 20:06:34 GMT

Hello tructran,

İf you want to do that in excel, you can use pivot in excel. But in values needs to be aggregation type such as sum,count etc.

Re: Matrix visual show

tructran — Wed, 11 Sep 2024 08:00:40 GMT

I want to do it in Power BI, not excel. So If you want to show like that in Power BI, you have to use Matrix visual! So I'm finding the custom matrix visual that we can change color of row header. You know what i mean!!

Re: Matrix visual show

uzuntasgokberk — Wed, 11 Sep 2024 08:09:07 GMT

Hello tructran,

I’ve been trying to help by showing how to use both the matrix and table default visualizations in Power BI in my earlier comment. I understand that you're looking for a custom solution, but I would kindly ask for more respectful communication. Wishing you the best of luck in finding the solution you're after.

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk