Matrix visual show

[tructran]

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

[tructran]

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!

[uzuntasgokberk]

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

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[tructran]

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! 

[uzuntasgokberk]

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.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[tructran]

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!!

[uzuntasgokberk]

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

[uzuntasgokberk]

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.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |