cancel
Showing results for 
Search instead for 
Did you mean: 

Insane bug on conditional formatting / matrix visualization

Pretty simple: once I try to resize any column in my Matrix, the conditional formatting goes crazy. See images below.

 

Bug1.PNGBeforeBug2.PNGAfter

Status: Needs Info
Comments
Moderator

@Ale,

What version of Power BI Desktop do you use? I am unable to reproduce this issue using my sample table in Power BI Desktop November release(2.64.5285.741).

Could you please share sample data of your table so  that I can replicate the Matrix visual?

Regards,
Lydia

Moderator
Status changed to: Needs Info
 
Ale Regular Visitor
Regular Visitor

Hi, I'm using the September vesion. Unfortunately my company has not updated it to November's yet.

I can't share the file but I found a way to reproduce it. It actually has to do with replacing one of the measures.

Step 1: Create 2 Measures (e.g.: Value and Trend);
Step 2: Add them to the Matrix;
Step 3: Set a conditional formatting (background for Value and font for Trend).
Step 4: Create a new Measure (e.g.: "NewValue");
Step 5: Add this "NewValue" to the Matrix and remove the old "Value"; (you can rename it or not, the bug appears in any case)
At this point, the previous conditional formatting will be lost, since the old "Value" was removed from the table.
Step 6: Create the Conditional Formatting again for the "NewValue" measure.
After step 6, whenever you resize a column, all the conditional formatting goes weird - edit: apparently it applies the background format to the "Trend" variable, based on its values, even if in the Trend conditional formatting background is switched off.

I just reproduced it with random data and that's the result:

Bug01.PNGBefore resize columnBug02.PNGAfter resize column

 

For that I used a dummy CSV file:

KPI,Column1,Column2
1,1,3
1,6,5
2,2,7
2,7,2
3,9,7
3,4,4
4,2,7
4,1,2
5,5,1
5,8,0

Created 3 Measures to reproduce it:

Value = AVERAGE(Sheet1[Column1])
Trend = SUM(Sheet1[Column2])
NewValue = AVERAGE(Sheet1[Column1])+3

Conditional formatting I used the default one:
For Value and NewValue, I used Background color only;
For Trend, I used Font color only;

Still, the background color from the "NewValue" is affecting the "Trend" variable.

Hope that is enough for you to reproduce it, if not, please let me know.

Moderator

@Ale,

Please  update your Power BI Desktop version to November version(2.64.5285.741). Conditional formatting works as expected after I follow your steps resizing columns.

Regards,
Lydia