Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
chrismcdonald
Helper I
Helper I

Conditional Formatting issues

I have an issue where my conditional formatting isn't being displayed correctly for all rows in my data.

 

It displays correctly until I add the column on the far right and then it only displays the conditional formatting for the row where there isn't a blank in the column on the far right. 

 

The Issue

 
 
1 ACCEPTED SOLUTION

Maybe, hard to say without sample source data and formulas. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

You can turn off word wrap and then shrink the last column down to nothing.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

8 REPLIES 8
chrismcdonald
Helper I
Helper I

Photos didn't end up posting in the original post

 

2020-03-31_0-59-52.png2020-03-31_1-01-12.png2020-03-31_1-01-41.png2020-03-31_1-02-12.png

Greg_Deckler
Super User
Super User

Should there be a screen shot? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

 

@Greg_Deckler you were too quick for me.. 😄 

 

yes there should have been but they didn't attach in the original post

 

Cheers,

 

 

Hmm, is Installation finished ref? a column or a measure? I am assuming column, correct? What happens if you add that column with the default Min aggregation to that, I'm guessing table visualization?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler  Thank you for the quick response and a possible solution.

 

Installation finish Ref? is a Columnand if I do add that Column to the table visualization then it does fix the conditional formatting issue.

 

Is there a way I can fix the issue without adding a new column to the table?

 

image.png

 

Thank you

Maybe, hard to say without sample source data and formulas. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

You can turn off word wrap and then shrink the last column down to nothing.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Thank you so much for your assistance.. This is more than enough for me to keep working on what I need now.

 

Cheers,

Awesome!


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors