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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
nsundareswaran
Frequent Visitor

conditional formatting in a Matrix Visual for a column field

Hello!
I have build a Matrix visual as shown below. All I wanted to do is how to Format the font colours as shown in the below table.
The column tile in the matrix has only two values - "Included in the flow" and "Not included in the flow". The  matrix visual has to format all the values to Green if it is "included in the flow"  and to Red if it is "not included in the flow".

nsundareswaran_0-1705648298485.png

 

1 ACCEPTED SOLUTION
v-huijiey-msft
Community Support
Community Support

Hi @nsundareswaran ,

 

Hope all is going well.

 

Based on the screenshot you provided, I understand your requirement is to set the font color of the "Included in the flow" column to green and the font color of the "Not Included in the flow" column to red.

 

I have achieved this requirement and my steps are:

vhuijieymsft_0-1705905407370.png

 

• Select the Specific column of Visualizations:

vhuijieymsft_1-1705905426308.png

 

• Select the columns you want to apply:

vhuijieymsft_2-1705905435204.png

 

• Select the color to apply to the corresponding column:

vhuijieymsft_3-1705905442161.png

 

Should you have any questions or concerns, please do feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

View solution in original post

2 REPLIES 2
v-huijiey-msft
Community Support
Community Support

Hi @nsundareswaran ,

 

Hope all is going well.

 

Based on the screenshot you provided, I understand your requirement is to set the font color of the "Included in the flow" column to green and the font color of the "Not Included in the flow" column to red.

 

I have achieved this requirement and my steps are:

vhuijieymsft_0-1705905407370.png

 

• Select the Specific column of Visualizations:

vhuijieymsft_1-1705905426308.png

 

• Select the columns you want to apply:

vhuijieymsft_2-1705905435204.png

 

• Select the color to apply to the corresponding column:

vhuijieymsft_3-1705905442161.png

 

Should you have any questions or concerns, please do feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

audreygerred
Super User
Super User

Hi! You can set conditional formatting by going into the formatting for your viz, expanding cell elements and configuring what you want: 

audreygerred_0-1705681497467.png

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.