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
Anonymous
Not applicable

How to Change the Font Color of Power BI Column

Hello All,

 

I had Unpiviot the columns of power bi table to and pushed one the column(Value) in values section as shown below.

And it has Values like Completed, Blcoked,-InProgress .And I would like to change the color of these value column
Can any one please help  how can I change the color 
Capture2.PNG

 

 

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

Hi @Anonymous ,

You can try the following steps to  format a row of numbers in Power BI(the following steps is only a sampleThe specific use is adapted to your table and visual,the sample show change background color ,and if you want to change the font color ,you could try the following)

 

v-luwang-msft_4-1621580607886.png

 

Step 1,create a color measure:

Measure Value Color = IF(MAX('Table'[Point])<=50,"#ff0000","#000000")

 

v-luwang-msft_0-1621580566618.png

 

 

Then:

v-luwang-msft_1-1621580566622.png

 

v-luwang-msft_2-1621580566624.png

 

Then you will see:

v-luwang-msft_3-1621580566625.png

 

More about how to configure color measure,you can see the below:

https://community.powerbi.com/t5/Desktop/Colour-formatting-on-Measure/m-p/864818#M414953

 

 

Wish  it is helpful for you!

 

Best Regard

Lucien Wang

View solution in original post

5 REPLIES 5
RJ251997
Helper I
Helper I

Hi @Anonymous ,

 

you can try condtional formating on those column 

RJ251997_0-1621592831212.png

thank & Regards 

Rohit

 

v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

You can try the following steps to  format a row of numbers in Power BI(the following steps is only a sampleThe specific use is adapted to your table and visual,the sample show change background color ,and if you want to change the font color ,you could try the following)

 

v-luwang-msft_4-1621580607886.png

 

Step 1,create a color measure:

Measure Value Color = IF(MAX('Table'[Point])<=50,"#ff0000","#000000")

 

v-luwang-msft_0-1621580566618.png

 

 

Then:

v-luwang-msft_1-1621580566622.png

 

v-luwang-msft_2-1621580566624.png

 

Then you will see:

v-luwang-msft_3-1621580566625.png

 

More about how to configure color measure,you can see the below:

https://community.powerbi.com/t5/Desktop/Colour-formatting-on-Measure/m-p/864818#M414953

 

 

Wish  it is helpful for you!

 

Best Regard

Lucien Wang

amitchandak
Super User
Super User

@Anonymous , if you talking about values of attributes, then it not possible as of now with the standard matrix as conditional formatting is not supported.

 

For value in values, you can use conditional formatting

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
Anonymous
Not applicable

Condition Formating is not being applied for Value which in value Section

@Anonymous 

 

From my knowledge, and for your case, in a matrix visual you can apply conditional formatting on quantitative data not on qualitative

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!

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.