Forum Discussion
Helper IIHighlight a specific bar based on slicer selection
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:
Helper IIHi Paul. Thanks for the advice. Here is the link to the Google Drive file. Hopefully, that works.
Yes, I was starting to work through the thread. it looks like it could be good. It's just more involved, and i was hoping to get away with being lazy. 😉 But I'm grabbing some coffee and working through it.
Thanks for your efforts!
Paul
Community ChampionJust 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:
- paulmorgan
This is really embarrassing. haha. I double-checked the names, and they match exactly. But I tried the approach anyway, and I still can't get it to work. Would you maybe share the file you created? I must still be doing something just silly wrong. Thanks for you persistence!
- paulmorgan
For some reason I needed to delete the slicer and create a new one. Then things started working as you outlined. Thanks very much for your help.