Forum Discussion
Helper IIIconditional 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 users made orders after 2 days
3: percentage of users made orders after 3 days
(same thing for 4,5,6,7)
users with placed orders 😞 total users placed orders between 0 to 7 days)
i want to make the color diverge between the rows (from 0 to 7) however the conditional formating filters only for the column
current table output:
tried to get the result with a matrix visual, but matrix will show the total users as 100% and i want to keep the number only for the total while other fields as perecentage.
3 Replies
v-zhangtiCommunity Support
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.
lawadaim 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
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.