Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hi,
Need Help!
Here is the table i have got.
I want to colour Start%, Finish% coloumns which have percentage values. (They are measured)
If the figures are more than 100% and text; infinity, colour them to Green otherwise Red.
Tried to use conditional formatting funtion PIB but couldn't get what i desire.
Is it possible?
Thanks for any help in advanc.
Solved! Go to Solution.
Hi @Anonymous ,
On the condittional formatting you need to place the rules condition then just do it with the following setup:
As you can see it's working as you describe.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
On the condittional formatting you need to place the rules condition then just do it with the following setup:
As you can see it's working as you describe.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThe Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 50 | |
| 43 | |
| 36 | |
| 33 | |
| 30 |
| User | Count |
|---|---|
| 138 | |
| 120 | |
| 60 | |
| 59 | |
| 56 |