cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AClerk New Contributor
New Contributor

Field formatting fail with a single record

Hey All,

I have this strange issue.

I have a field formating based on another field.

All works fine, except for 1 record.

Any ideas whats going on here?
2019-06-26 14_24_01-papercut - Remote Desktop Connection.png2019-06-26 14_18_33-papercut - Remote Desktop Connection.png

 

Thanks
A

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
AClerk New Contributor
New Contributor

Re: Field formatting fail with a single record

Root cause: Duplicated record!
All fields were identical, except for the primary key of course.

Power BI will not load duplicate records to the view by default. Apparently, it has some other issues with duplications. As we noticed here, formatting issues.

 

Thanks!
A

View solution in original post

9 REPLIES 9
Super User IV
Super User IV

Re: Field formatting fail with a single record

Because the value for that record is returning a blank (no data being returned) it is not applying the formatting.  You are saying "Format this based on that" but on the record you are pointing to there is no "This".

AClerk New Contributor
New Contributor

Re: Field formatting fail with a single record

Hey @jdbuchanan71 

 


@jdbuchanan71 wrote:

Because the value for that record is returning a blank (no data being returned) it is not applying the formatting.  You are saying "Format this based on that" but on the record you are pointing to there is no "This".


 

Not sure I get you.

The format is based on the value in 'Days to Review' column. The value there is 269.

So there is a value. Or I did not understand?!
Thanks!
A

Super User IV
Super User IV

Re: Field formatting fail with a single record

Right but you are formatting the review date and on the row there is no review date to format.  Try this, apply the same formatting to the [Days To Review] column and that row should format correctly in the [Days To Review] column.

AClerk New Contributor
New Contributor

Re: Field formatting fail with a single record

Hey @jdbuchanan71 

Thanks again.

The value is there. Just the font colour is white, so cannot see it.

The value in days to review is based on this date value. if it was blank, I would have got blank value or 0.

Here it is when I am pointing with my mouse at it.

Untitled.png

 

And again when formatted to pink

2019-06-26 16_23_21-papercut - Remote Desktop Connection.png

 

Cheers!
A

AClerk New Contributor
New Contributor

Re: Field formatting fail with a single record

Applied the same on the days to review column, and have the same issue.

Robot Mad

 

2019-06-26 16_27_15-papercut - Remote Desktop Connection.png

Super User IV
Super User IV

Re: Field formatting fail with a single record

Hello @AClerk .

Thank you for the test, sorry I led you down the wrong path.  Is there any other formatting applied to that column?  You have the text as white, maybe the same rule that is applying the white text is also applying a white background?  If so and that rule is applied after the color coding rule the it would change it to white.

Community Support Team
Community Support Team

Re: Field formatting fail with a single record

Hi @AClerk ,

 

Based on my test, I cannot reproduce your issue here using Power BI desktop version : 2.71.5523.361 64-bit (July 2019). Could you please update your Power BI desktop to check again. If the issue still occure, kindly share your sample pbix to me if you don't have any confidential information. Please upload your files to One Drive and share the link here.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
AClerk New Contributor
New Contributor

Re: Field formatting fail with a single record

Hey @jdbuchanan71 

No worries mate. My screenshot might have been misleading.

I have formatted all fonts to be white, without any condition.

Anyhow, I found the root cause. I will post it shortly.

Cheers!
A

Highlighted
AClerk New Contributor
New Contributor

Re: Field formatting fail with a single record

Root cause: Duplicated record!
All fields were identical, except for the primary key of course.

Power BI will not load duplicate records to the view by default. Apparently, it has some other issues with duplications. As we noticed here, formatting issues.

 

Thanks!
A

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors