Forum Discussion

abihoughton27's avatar
abihoughton27
Icon for Helper I rankHelper I
3 years ago
Solved

Conditional Formatting - Icons to show if the previous value was higher or lower

Hello 🙂   I am looking to do some conditionl formatting comparing each months values.   I want to use icons if the value is the same as the previous month a straight arrow, if the value is lower...
Need Help
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    3 years ago

    abihoughton27 , Create a MOM measure and use that conditional formatting

     

    MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
    last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))

     

    Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
    Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
    Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

     

     

     

    diff = [MTD Sales]-[last MTD Sales]
    diff % = divide([MTD Sales]-[last MTD Sales],[last MTD Sales])

abihoughton27's avatar
abihoughton27
Icon for Helper I rankHelper I
3 years ago

Thank you amitchandak that was really helpful and clear,

 

I am now trying to do my conditional formatting but it won't let me enter - values 

 

 

i have also done it with diff %

 

 

 where am i going wrong?