March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
125 | |
84 | |
66 | |
54 | |
43 |
User | Count |
---|---|
200 | |
107 | |
96 | |
64 | |
56 |