Forum Discussion

Atanas_Atanasov's avatar
Atanas_Atanasov
Icon for Helper II rankHelper II
7 months ago
Solved

Conditional Formatting Based On Multiple Crieria (sorry I searched, but couldn't find solution)

Dear community, I have a simple table loaded in power BI which looks like that (screenshot 1)   The metric column and the quarter columns are coming from a single table named "Quarterly Resu...
  • Praful_Potphode's avatar
    Praful_Potphode
    7 months ago

    Hi Atanas_Atanasov ,

    You can use Visual Calculation(Select Your Visual and click on New Visual Calculation) to achieve the result shown below:

    PFA PBIX.

    Please give Kudos or mark it as solution once confirmed.

     

    Thanks and Regards,

    Praful

     

Praful_Potphode's avatar
Praful_Potphode
Icon for Super User rankSuper User
7 months ago

Hi Atanas_Atanasov ,

You can use Visual Calculation(Select Your Visual and click on New Visual Calculation) to achieve the result shown below:

PFA PBIX.

Please give Kudos or mark it as solution once confirmed.

 

Thanks and Regards,

Praful

 

  • Atanas_Atanasov's avatar
    Atanas_Atanasov
    Icon for Helper II rankHelper II
    7 months ago

    Praful_Potphode - Thank you so much! That resolved my issue. I have also accomplished the coloring with disconnected table where i just put the values of the metric column. Then dragged it into the matrix and applied the same code:

    if( metric name = "BF Surveyable Events" && [BF Surveyable Events] > 7 && [BF Surveys] = 0, 1, 0 )
    But this works only with disconnected table. However, your solution is simpler and more elegant. Thank you one more time.