Forum Discussion

realiza's avatar
realiza
Frequent Visitor
5 years ago
Solved

Highlight Values with Changes

Hi,    I have a historical data where on the report I used a table and it needs to change the background or font color on each column per group (which is community) per row. It should show be shown...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi realiza ,

     

    Depending on your question, you can set the color of a specific row field in Format-> Conditional formatting.

     

    Here is the reference detail document link.Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi realiza ,

 

Depending on your question, you can set the color of a specific row field in Format-> Conditional formatting.

 

Here is the reference detail document link.Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • realiza's avatar
    realiza
    Frequent Visitor
    5 years ago

    Hi v-henryk-mstf 

    the changes per column may be lower or higher from the previous row, so the conditional formatting can't be applied here because of the min or max aggregate does not apply here. 

    • v-henryk-mstf's avatar
      v-henryk-mstf
      Community Support
      5 years ago

      Hi realiza ,

       

      Currently in powerbi desktop, for the above functions, only conditional judgments can be made on specific aggregated values and then the color can be changed. What are the judgment conditions for changing the color in each row and column of the above table?


      Looking forward to your reply.

      Best Regards,
      Henry

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • realiza's avatar
        realiza
        Frequent Visitor
        5 years ago

        hi v-henryk-mstf 

         

        the table actually is a historical table, so if there is any changes (com-type to topic columns, but there are more columns) in the community column. The users input all activity evey now and then, that is why no condition to know what changes is inputted.