Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

What if Analysis

Hi Community! 

Any idea on how to use Conditional Formatting in What-If Analysis? 

Basic and Advanced both. 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous Conditional Formatting in What-If Analysis? or using What-If Analysis ?

     

    You can create a measure that returns color based on condition and use that in the conditional formatting advance option using field value option

     

    example

    Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
    Color Year = if(FIRSTNONBLANK('Table'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Basically, I'm going to use Icons instead of colors in formatting and want it to change according to the slicer 

      So if I change my cost parameter accordingly, it'll reflect on What if profit in the table and I want to change the icons accordingly. Eg: If I set my limit between 0-20% as Down(Red Arrow) and after dragging the slicer to the positive or negative side. if it goes above 20% then the Icon should change to Up(Green Arrow) or vice versa. 

      Hope you get what I'm trying to say!