Help to conditional format text in a specific Column

[Jwood993]

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

[Jwood993]

Hello please let me know if more information is required

[SolomonovAnton]

could you share your pbix file ?

I think it will be best way for resolve case 

[SolomonovAnton]

hello ! 

you should create measure 

color = 
var _RowsCnt = COUNTROWS('Table')
var _Result = IF(_RowsCnt>1,"Green",BLANK())
return _Result

after do apply it measure to conditional formating background 

do the same settings 

you will get follow result 

if I answered at your question please make topic as resplved 🙂

[Jwood993]

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.

Thanks

[SolomonovAnton]

please describe with more details then I could be help you 

[Jwood993]

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)

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.

I've attached another image to try and show what I need

Thanks 

[amitchandak]

@Jwood993 , Create a measure 

color =

var _cnt = countx(filter(allselected(Table) , [Name] =earlier([Name]) ), [Name])

return

if(_cnt >1, "Green" , "White")

Use this in conditional formatting, using field value option

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...

[Jwood993]

Hi when editing it comes up with some error

- The main sheet is called "Convert" but Store Name is a header in that sheet