Highlight table by slicer

[Anonymous]

Hi I have a power BI matrix table where i am showing cost center wise forecast and actuals. Now i've created a slicer based on cost center list. Now i want when i select a cost center from that slicer it would highlight that cost center in that table instead of filtering it from the entire table.

The DAX formulae i used is below 

Highlight =

VAR selectedpu =ALLSELECTED(PU_Lookup[Prod Unit Code])

return

IF(ISCROSSFILTERED(PU_Lookup[Prod Unit Code]),if(max('Regular TB'[Actuals]) IN selectedpu, 0, 1), 1)

after that when i used that measure to in conditional formatting it  gives me following error
"Mdxscript(Model) (31,80) calculate error in measure (table_name[Highlight]: function 'CONTAINSROW' does not support comparing values of type of text with type of numbers. Consider using the VALUE or FORMAT function to convert one of the values."

any idea what is going wrong?

[v-xulin-mstf]

Hi @Anonymous

Is your issue solved? If the issue has been solved, please adopt the solution to help others.

The measure works well in my encironment, please change the data type according to the error message and check.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[lbendlin · Accepted solution]

You have a field type mismatch between [Prod Unit Code]  and [Actuals].  Please correct that.