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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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.


@ 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!:
The Definitive Guide to Power Query (M)

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


@ 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!:
The Definitive Guide to Power Query (M)

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?


@ 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!:
The Definitive Guide to Power Query (M)

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.


@ 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!:
The Definitive Guide to Power Query (M)

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!

@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.