topic conditional formatting for rows in table visual in DAX Commands and Tips

conditional formatting for rows in table visual

lawada — Wed, 08 Dec 2021 12:32:32 GMT

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.

Re: conditional formatting for rows in table visual

v-zhangti — Mon, 13 Dec 2021 02:02:05 GMT

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.

Re: conditional formatting for rows in table visual

lawada — Mon, 13 Dec 2021 06:53:22 GMT

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

Re: conditional formatting for rows in table visual

v-zhangti — Tue, 14 Dec 2021 09:10:03 GMT

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.