Help to conditional format text in a specific Column

Question

Hi I want to achieve something on my report where the data will conditional format for any text value that is repeated more than once. I want this to highlight to the viewer that the text is appearing more than once after the data has been filtered. I've been trying for a long time to figure it out and can't seem to make it work.

I've attached a photo of the desired outcome if possible

Thanks

amitchandak · Answer

Jwood993 , Create a measure&nbsp;
&nbsp;
color =
var _cnt = countx(filter(allselected(Table) , [Name] =earlier([Name]) ), [Name])
return
if(_cnt &gt;1, "Green" , "White")
&nbsp;
Use this in conditional formatting, using field value option
&nbsp;
How to do conditional formatting by measure and apply it on pie? https://www.youtube.com/watch?v=RqBb5eBf_I4&amp;list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8Lhttps://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539

solomonovanton · Answer

hello !&nbsp;&nbsp;you should create measure&nbsp;color = 
var _RowsCnt = COUNTROWS('Table')
var _Result = IF(_RowsCnt&gt;1,"Green",BLANK())
return _Result&nbsp;after do apply it measure to conditional formating background&nbsp;do the same settings&nbsp;&nbsp;you will get follow result&nbsp;&nbsp;if I answered at your question please make topic as resplved 🙂&nbsp;&nbsp;

jwood993 · Answer

Hi It's not working and it doesn't let me select the specific column heading that i want to assign the formatting to. It only comes up with the original table name.&nbsp;Thanks

solomonovanton · Answer

please describe with more details then I could be help you&nbsp;

jwood993 · Answer

Basically what I'd like to achieve is that in my table there is separate columns that show the name and store someone works at. It also shows different projects that are launching and I'd like to highlight store names where multiple projects might be going live that week (I've got all the filters setup already)&nbsp;So if in store 5555 there is 3 events happening it highlights to alert the viewer that there's large amounts of activity occuring at once.&nbsp;I've attached another image to try and show what I need&nbsp;Thanks&nbsp;&nbsp;&nbsp;

Forum Discussion

Help to conditional format text in a specific Column

8 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting