Forum Discussion
Second layer of Cell Elements (Conditional Formatting)
I've seen in a colleagues report in a matrix visual the following:
How do you do that? I need that :).
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:
- Make sure you’re using the latest version of Power BI Desktop.
- In your matrix visual, select the field you want to format.
- Go to the “Format” pane > “Cell elements.”
- 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
6 Replies
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:
- Make sure you’re using the latest version of Power BI Desktop.
- In your matrix visual, select the field you want to format.
- Go to the “Format” pane > “Cell elements.”
- 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 AINew functionality, sweet.
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 KumarIs 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.
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
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
