cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

Rules for Background color change in table is not working as expected

I have a calculated measure called complete%. That is one of my field in table view. Given the below rules for background color.

 

1.JPG

In below report you could see, the colors are as expected.

 

SabariPrabu_0-1603365655897.png

 

However once i filter the whole report by clicking on pie chart, the colors are not followed as per the rules. How this can be corrected ?

 

SabariPrabu_1-1603365752563.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Resolver IV
Resolver IV

Hi 

While creating a rule, instead of using percentage in the dropdown try use number. (For ex: 10% means 0.1 as number. )

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

View solution in original post

2 REPLIES 2
Resolver IV
Resolver IV

Hi 

While creating a rule, instead of using percentage in the dropdown try use number. (For ex: 10% means 0.1 as number. )

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

View solution in original post

Community Support
Community Support

Hi @SabariPrabu 

In additional to nvprasad 's reply, I build a sample to you. You may set conditional format as below.

1.png

Result:

2.png

You can download the pbix file from this link: Rules for Background color change in table is not working as expected

 

Best Regards,

Rico Zhou

 

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors