Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Alexandra_B
Helper III
Helper III

Reg/green KPI (Probably) if data in not in the selected parameters.

Hello.

Is there a command that can flag red if a value is <10 for example, and green if it`s over?

I have a couple of fields (data from meter readings: Wh, power, cost, etc). I would like to create an "Issues" report to flag when any of them are not recording data or is not in the required range.

Thank you for any help.

 

issues.png

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Alexandra_B , Not very clear. but conditional formatting can help

Learn Power BI Advance - PowerBI Abstract Thesis: How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Alexandra_B , Not very clear. but conditional formatting can help

Learn Power BI Advance - PowerBI Abstract Thesis: How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors