Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
76 | |
61 | |
37 | |
33 |
User | Count |
---|---|
99 | |
56 | |
51 | |
42 | |
40 |