Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
vanessa
Post Patron
Post Patron

% Change

‎07-22-2016 06:42 AM

I have 2 columns:

sales for current year and sales for previous year.

I want to compare the total of both, and display if there has been an increase or decrease (% change) along with conditional formatting (either green or red)

Is there a visual i can use?

Message 1 of 3
758 Views
0
2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

‎07-22-2016 11:30 AM

Tables support conditional formatting:

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-update-feature-summary/

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Message 3 of 3
743 Views
Vvelarde
Community Champion
Community Champion

‎07-22-2016 08:29 AM

hi @vanessa

 

You can use CardWithStatesBySQLBI

 

https://app.powerbi.com/visuals/




Lima - Peru
Message 2 of 3
748 Views
0

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All