Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
DouweMeer
Impactful Individual
Impactful Individual

Second layer of Cell Elements (Conditional Formatting)

I've seen in a colleagues report in a matrix visual the following:

 

DouweMeer_0-1749556608918.png

 

How do you do that? I need that :). 

1 ACCEPTED SOLUTION
burakkaragoz
Community Champion
Community Champion

Hi @DouweMeer ,


That’s the new “Cell elements” feature in the matrix visual – it lets you apply multiple layers of conditional formatting (like background color, font color, icons, etc.) on the same field.

How to get it:

  1. Make sure you’re using the latest version of Power BI Desktop.
  2. In your matrix visual, select the field you want to format.
  3. Go to the “Format” pane > “Cell elements.”
  4. Here, you’ll see all those options (like background color, font color, data bars, etc.) and you can turn on more than one at the same time—just like in your screenshot.

If you don’t see “Cell elements,” update your Power BI or check if you need to enable it in the “Preview features” (File > Options > Preview features > “Cell elements in the matrix visual”).

That’s it! Let me know if you get stuck or need more details.

View solution in original post

6 REPLIES 6
v-pgoloju
Community Support
Community Support

Hi @DouweMeer,

 

Just checking in to see if the conditional formatting using the Cell elements section in the matrix visual worked as expected. Were you able to apply the formatting to individual columns successfully?

If you have any further questions or need help with anything else, feel free to reach out.

Warm regards,
Prasanna Kumar

v-pgoloju
Community Support
Community Support

Hi @DouweMeer,

 

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

 

 

Best regards,

Prasanna Kumar

v-pgoloju
Community Support
Community Support

Hi @DouweMeer,

 

Thank you for reaching out to the Microsoft Fabric Forum Community.

 

In Power BI's matrix visual, you can apply different conditional formatting (like background color, font color, icons, etc.) to each column (called "series") using the "Cell elements" section. To do this, select the matrix visual, go to "Cell elements," and choose a column name from the dropdown under "Apply settings to." Then, turn on and customize the formatting you want. If you scroll down, you’ll see more entries for other columns, letting you apply separate formatting to each one.


Thank you & Regards,
Prasanna Kumar

DouweMeer
Impactful Individual
Impactful Individual

Is this AI? You can see that I'm referring to that functionality, right?

Someone else states it is the version that mismatches, must be it. 

burakkaragoz
Community Champion
Community Champion

Hi @DouweMeer ,


That’s the new “Cell elements” feature in the matrix visual – it lets you apply multiple layers of conditional formatting (like background color, font color, icons, etc.) on the same field.

How to get it:

  1. Make sure you’re using the latest version of Power BI Desktop.
  2. In your matrix visual, select the field you want to format.
  3. Go to the “Format” pane > “Cell elements.”
  4. Here, you’ll see all those options (like background color, font color, data bars, etc.) and you can turn on more than one at the same time—just like in your screenshot.

If you don’t see “Cell elements,” update your Power BI or check if you need to enable it in the “Preview features” (File > Options > Preview features > “Cell elements in the matrix visual”).

That’s it! Let me know if you get stuck or need more details.

New functionality, sweet. 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.