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
Anonymous
Not applicable

undefined

Hello,

 

I am trying to turn the Needs Approval to yellow. There is numbers in the fields at times as well but I am not sure of a measure that can decipher the two.

 

thanks

 

 

 

Rippey_1-1604002089244.png

 

 

3 REPLIES 3
v-jayw-msft
Community Support
Community Support

Hi @Anonymous ,

 

Please take a look at the below document. You may use conditional formatting if the visual is supported.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting 

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
amitchandak
Super User
Super User

@Anonymous , if it is a table you can do using the color measure. But not in the case of the matrix .

Example

color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)

 

You need to select "field value" option in conditional formatting and use this measure

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

NamishB
Post Prodigy
Post Prodigy

Hi @Anonymous  whats the visual you using? and you mean "Needs Approval" as a word to color as yellow or the numbers correspondings to Needs Approval to Yellow?

 

Conditional Formatting > Font Color enable and you can set some rules to show the fields as colored.

 

Hope this helps.

 

Cheers,

-Namish B

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.