Help with conditional formatting in power bi

[Poornima2023]

Hi I need help with formatting of matrix table like below.

[sivarajan21]

Hi @Poornima2023 

Do you want expected output as below? I created a solution as below:

we can color the region and all columns as shown above image.

Please let me know and i will inform the solution for you

[Poornima2023]

Please help. Also note its not table its matrix.

[sivarajan21]

Hi @Poornima2023 

I have a workaround for this if you don't have python installed.

We can create a SVG specification:

1. Create an SVG specification that includes a rectangle shape and a text element within it.
2. Create a conditional column in Power Query and place your specification in that column. Replace the text value in the SVG code with the column you want to add to your matrix row header. Also, replace the rectangle shape’s fill color with the color you want to use for that category. (You may need to write conditional logic using an IF statement to make it dynamic.)
3. Change the category of this column to "Image URL."
4. You can then place it in your matrix row header.

If you want i can implement this and give you the code and result

Please let me know!

Best Regards,

[sivarajan21]

Hi @Poornima2023 

Sure! 

I used plotly chart using python script to achieve this

You need to just click the PY in visualization and type in below code on scripts to achieve this. 

Before that do you have python installed on your machine?

Currently power bi doesn't provide formatting on all columns

Please let me know

Best Regards,

[KNP]

Region and Branch cannot be formatted, unfortunately. Matrix visuals don't allow it.

A-E and Total can be.

See example screenshot, using a measure to define the rules and then applying to the matrix on EACH of your columns (individually).

[Poornima2023]

Its coming like below

[V-yubandi-msft]

Hi @Poornima2023 ,
As @KNP mentioned earlier, conditional formatting cannot be applied to row headers such as Region and Branch in the matrix visual, so those fields cannot be colored. For any blanks that appear, you can adjust your measure logic to replace them with 0 or another value, which will help ensure conditional formatting is applied consistently.

Hope this helps, and thank you for your response, @KNP .

[Poornima2023]

Thanks tried it. Blanks in every region are coming white and also color is not coming on Region and branch

[KNP]

As I mentioned in my comment, region and branch cannot be conditionally coloured. 

The blanks you may need to change the blanks to zeros or a blank string. 

[anilgavhane]

1. Add Matrix Visual

• Open Power BI Desktop.

• From Visualizations, choose Matrix.

• Drag fields:

  • Rows: Region, then Branch

  • Columns: A, B, C, D, E (add these under Columns)

  • Values: Your metric (e.g., count or total value)

---

2. Enable Subtotals and Grand Totals

• Select the Matrix.

• Go to Format pane (paint roller icon).

• Expand Subtotals:

  • Turn Row subtotals ON.

  • Set Per row level to ON if needed.

• Expand Grand total:

  • Turn ON Row and Column totals if not already.

---

3. Apply Background Color by Region

To format each region's background color (like East = blue, South = green):

Method 1: Using Conditional Formatting

• In Fields pane, right-click your value (under Values) → Conditional formatting → Background color.

• Choose Format by: Field value or Rules

• Use a helper column in your data model that maps Region to color (e.g., East = light blue, South = light green, etc.)

• Or manually create rules like:

  • If Region = East → light blue

  • If Region = South → light green

  • etc.

[Poornima2023]

Thanks but its not working