Forum Discussion

lawada's avatar
lawada
Icon for Helper III rankHelper III
4 years ago

conditional formatting for rows in table visual

i have a table with measures that shows: month: month when the user placed order 0: percentage of users made orders in the same day 1: percentage of users made orders after 1 day 2: percentage of...
Help appreciated
Help Requested
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, lawada 

 

Can you share a simple PBIX document for testing? Is it possible to show the results you expect in excel images?

 

Looking forward to your response.

 

Best Regards,

Community Support Team _Charlotte

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

lawada's avatar
lawada
Icon for Helper III rankHelper III
4 years ago

im trying to change background color of each cell in a row  according to the values within  

ex. of how im expecting the output:

 i want the color to change according to the values between the measures 0 and 7  in a row

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, lawada 

     

    I've tested your problem and can't disperse colors based on rows. You can only diffuse the color by column, or you can set the color of the rows to be the same.

     

    For setting the row color to be consistent, you should refer to the following document.

    Solved: Conditional formatting on Rows - Microsoft Power BI Community

     

    Unfortunately, this is by design. Power BI is now unable to achieve what you need . You can submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

     

    Best Regards,

    Community Support Team _Charlotte

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