Forum Discussion

tructran's avatar
tructran
New Member
1 year ago

Matrix visual show

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

 

7 Replies

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

  • 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's avatar
      uzuntasgokberk
      Super User

      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's avatar
        tructran
        New Member

        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!