Format Rows

[quickbi]

Hi all,

I have Balance structure with a color for background and font depending on the line.
I format in  pivot table a cell value background color depending on these values, but when I put the formula based n the value background the pivot crash.

Thi is the base table:

Appliying the rule:

Before apply background rule

The result:

Any idea what I'm doing wrong?

Thanks

[Anonymous]

Hi @quickbi ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered?

It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

Hi @quickbi ,

Thanks for the reply from @parry2k .

As he said, what is the specific error message?

I created sample data for testing:

level	background
A	#FFFFFF
B	#FFFFFF
C	#FFFFFF
D	#FFFFFF
E	#FFFFFF

Set conditional formatting.

This is what it looks like before setting conditional formatting:

This is after applying conditional formatting:

It works fine.

If possible, can you provide me with the pbix file?

Remember to remove sensitive data and do not log in to your account in Power BI Desktop when uploading the pbix file.

The pbix file is attached.

If you have any other questions, please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[parry2k]

@quickbi what is the see details message?