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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mjmjn2611
Frequent Visitor

Highlight below or above the average price

Hi, 

 

I want to create a measure to highlight below or above the average price.

 

For example 

 

Customer       Price      Check

A                    5            below average ==> red

B                     7           above average ==> green

C                     6

1 REPLY 1
selimovd
Super User
Super User

Hey @mjmjn2611 ,

 

you can add the color as a calculated column:

Check = 
VAR vRowPrice = myTable[Price] 
VAR vAveragePrice = AVERAGE(myTable[Price])
RETURN
SWITCH(
    TRUE(),
    vRowPrice < vAveragePrice, "red", 
    vRowPrice > vAveragePrice, "green"
)

 

Then you can use that column for the conditional formatting:

selimovd_0-1622549950485.png

 

And that's then the result you get:

selimovd_1-1622549982608.png

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.