Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
Hi @Anonymous ,
You can try the following steps to format a row of numbers in Power BI(the following steps is only a sample ,The 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)
Step 1,create a color measure:
Measure Value Color = IF(MAX('Table'[Point])<=50,"#ff0000","#000000")
Then:
Then you will see:
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
Hi @Anonymous ,
you can try condtional formating on those column
thank & Regards
Rohit
Hi @Anonymous ,
You can try the following steps to format a row of numbers in Power BI(the following steps is only a sample ,The 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)
Step 1,create a color measure:
Measure Value Color = IF(MAX('Table'[Point])<=50,"#ff0000","#000000")
Then:
Then you will see:
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
@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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
83 | |
69 | |
68 | |
39 | |
37 |