Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

How to Get Your Question Answered Quickly

Ever wonder why some questions get answered so quickly while others languish or are seemingly completely ignored? Fear not, this article will help guide you into getting your question answered quickl...
Need Help
Tips and Tricks
Georgesunil77's avatar
Georgesunil77
Advocate II
4 years ago

Hi Team,
In column A we have actuals, B column is for forecast, C column is the difference between A and B columns

Can I manually edit B column (forecast) in Power BI Matrix table ?

 

Regards,

Sunil

    • Georgesunil77's avatar
      Georgesunil77
      Advocate II
      4 years ago

      Thanks aton Miguel !
      One more question I had, I am trying to replicate the below formula which I have in excel :
      =IF(AR9="No BoM",100%, AV9/AX9)

      How do we put an if conditon in Power BI for a TEXT
      if AR column contains "No BoM", Then give me 100% or give me the formula AV9/AX9.

       

       

      Regards,

      George

      • MFelix's avatar
        MFelix
        Super User
        4 years ago

        Hi Georgesunil77 ,

         

        This depends on how you have the values but this can be something similar to:

         

        Percentage Value = IF(SELECTEDVALUE(Table[Column]) = "No BoM", 1 , Divide(SUM(Table[Column]),SUM( Table[Column]))

         

        Then just format has percentage.

    • Georgesunil77's avatar
      Georgesunil77
      Advocate II
      4 years ago

      Hi Team,

      You might have come across this situation where we would need to depict waterfall graph with Current Year and Prior Year bars on either sides of the graphs.

      CY and PY should be of dark blue colour.

      All the ups and downs inbetween should be red and green.

      Please help me to solve this.

       

      Regards,

      George