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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Lozza
Regular Visitor

Conditional formatting based on changing values

Hello,

I've been asked to show a graphic in a report that has up and down arrows to show the change from quarter to quarter.  I'm fairly new to PBI and have looked at lots of the replies online etc. but I can't get the to work as I think they should.

If I was working in Excel, I would use an IF Function, if this is > than that, Red.

The data I am working with is a specific count of something, there is no working out a percentage of a target number, it is either more than, or less than, the number in the previous month, an example below.

 

ColourQ1Q2
Pink99
Yellow814
Blue2751
Green82
Red50
Orange03

 

Please can anyone help?

Many thanks,

Lozza

 

 
3 REPLIES 3
lbendlin
Super User
Super User

what would the expected outcome look like based on your sample data?

ColourQ1Q2 
Pink99=
Yellow814up arrow
Blue2751up arrow
Green82down arrow
Red50down arrow
Orange03up arrow

 

Either up and down arrows and an equals sign, or a colour coded symbol (red for down, yellow for equals, green for up)?

 

Thank you for looking at this for me.

lbendlin_1-1707926119860.png

 

This is one option - feel free to modify

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Solution Authors
Top Kudoed Authors