Forum Discussion
paulmorgan
Helper II
Helper IIHighlight a specific bar based on slicer selection
Hi I implemented a suggestion found here in the forums. I must be doing something wrong. It's not working. I have a chart that lists some values for each country in a region. In the example, ...
Just checked out your sample file. The problem is that the country names in the 'tableCountry' table don't match the country names in the 'Lists' table (probably an extra space at the end or something)
I Just created a new table to check it out using DISTINCT and you get this:
amitchandak
Super User
Super Userpaulmorgan , This seems correct to me
Try this. Just sure country names are matching
colorFocus = IF( MAX ( Lists[Country] ) in allselected(tableCountry[Country] ),"Red","Grey")
I am assuming List is name of column, that is used on x-axis
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.