Forum Discussion

hammerblue's avatar
hammerblue
Icon for Helper I rankHelper I
8 years ago
Solved

Matrix formatting in 2018 september demo

Does anyone know how they made the matrix table shown in the 2018 september demo? https://powerbi.microsoft.com/sv-se/blog/power-bi-desktop-august-2018-feature-summary/   Specifically how value r...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi hammerblue,

     

    Please refer to the snapshot below. Set the 1 and 2 Grey and the 3 White.

    Matrix_formatting_in_2018_september_demo2

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi hammerblue,

 

Please refer to the snapshot below. Set the 1 and 2 Grey and the 3 White.

Matrix_formatting_in_2018_september_demo2

 

Best Regards,
Dale

hammerblue's avatar
hammerblue
Icon for Helper I rankHelper I
8 years ago

I'm gonna accept this as the solution because it is indeed how you do it, but it still doesn't work for me.. When set the background and alternate background color for values to the same color value it defaults back to white for the row headers for some reason, but not the values... i suspect it's a bug having to do with the fact i'm using a custom theme.

 

I've set the background and alternate background colors to the same gray as the values, yet they turn white.

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi hammerblue,

     

    Can it work when you set up the Row headers in the settings?

    Matrix_formatting_in_2018_september_demo3

     

    Best Regards,
    Dale

    • hammerblue's avatar
      hammerblue
      Icon for Helper I rankHelper I
      8 years ago

      No, that turns the entire column of row headers into that color.