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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

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.
translation and formatting supported by AI

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.
translation and formatting supported by AI

New functionality, sweet. 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors