Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Coditional formatting matrix values based on text field

Hi,   I have a matrix with categories on rows (blacked out) week num (1..52) and day (mon to sun) on columns and some dates as values when a submission was made..   I want to give backg...
Need Help
  • Alf94's avatar
    Alf94
    3 years ago

    Hi Anonymous ,

     

    First change the default background of your lines to red. Then add a conditionnal formatting to your dates used as values.

     

     

    You have to use the day field ("JourNom" in my report) in your conditionnal formatting.

     

     

    Finally:

     

     

    If I answered to your question, please mark my post as a solution.

     

    Best,

     

Alf94's avatar
Alf94
Solution Supplier
3 years ago

Hi Anonymous ,

 

First change the default background of your lines to red. Then add a conditionnal formatting to your dates used as values.

 

 

You have to use the day field ("JourNom" in my report) in your conditionnal formatting.

 

 

Finally:

 

 

If I answered to your question, please mark my post as a solution.

 

Best,

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I'm not able to enter a text value for the condition.. its only accepting a numeric value

     

    • Alf94's avatar
      Alf94
      Solution Supplier
      3 years ago

      This option has been available since (I think) the beginning of 2023. If your version of PBI Desktop is older, you can either update your application, or try using a field like "DayNumber" (1 for Monday, 2 for Tuesday, ..., 7 for Sunday). Then create a rule that says "green background when the minimum of my day number equals 4" (for Thursday) and the same for 7 (for Sunday).

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Thank you Alf94 

        I updated the desktop app and it works now. Thanks again!