cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bebeto Member
Member

Table conditional formatting

Hi,

 

I have the Power BI Desktop Version: 2.43.4647.541 32-bit (febrero de 2017)

 

And I can't see the option Conditional Formatting in the table values... Before updating the version I could see it, does this version change this feature or am I doing something wrong?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-yulgu-msft
Microsoft

Re: Table conditional formatting

Hi @bebeto,

 

No. Unfortunately, this is not a supported functionality right now.

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Microsoft v-yulgu-msft
Microsoft

Re: Table conditional formatting

Hi @bebeto,

 

The 'Conditional Formatting' option is still available in version: 2.43.4647.541 (Feb 2017). But this option only applies to aggregated values or measures. Otherwise, it is disable if you don't summarize the value field.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bebeto Member
Member

Re: Table conditional formatting

Thanks @v-yulgu-msft,

 

So, can I apply conditional formatting to change de font color of a text column if the condition is Column = "Hello"?

Microsoft v-yulgu-msft
Microsoft

Re: Table conditional formatting

Hi @bebeto,

 

No. Unfortunately, this is not a supported functionality right now.

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

bebeto Member
Member

Re: Table conditional formatting

Ok, thanks. And is it considered in next versions?

Ahmad90 New Member
New Member

Re: Table conditional formatting

Hey

 

I found a workaround for this. First, choose an aggregated function for example Sum (even though you might not need to do this function). Then apply the conditional formatting for this field. After that remove the function by checking "don't summarize option" when clicking right by the name of the field on the visualization navigation bar. Amazingly, it keeps the conditional formatting. 

 

Check it out 🙂 

Highlighted
sreenu Frequent Visitor
Frequent Visitor

Re: Table conditional formatting

Hi bebeto,

 

The 'Conditional Formatting' option is available only aggregated values or measures.Otherwise, it is disable if you don't summarize the value field.

 

Thanks,

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.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors