Forum Discussion

paulmorgan's avatar
paulmorgan
Icon for Helper II rankHelper II
5 years ago
Solved

Highlight 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, ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    paulmorgan 

    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:

     

paulmorgan's avatar
paulmorgan
Icon for Helper II rankHelper II
5 years ago

Thanks very much for your suggestion. Unfortunately, it didn't work for me. I created a sample file, but I guess I don't "rank" being able to upload pbix files, and my company doesn't allow for people outside the company to access OneDrive files, and I don't have a Dropbox account. I tried uploading to Google Drive, but it gives me basically a "file structure" when I click on it instead of an actual pbix file. 

 

If you have any other suggestions on how to share the file, let me know. Regardless, I do appreciate your willingness to help out!

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

paulmorgan 

Google Drive is fine (even though you "see" a file structure, if you download you get the PBIX file). Alternatively, try a file transfer service such as:

Wetransfer 

Btw, did you check out the suggested thread ?

  • paulmorgan's avatar
    paulmorgan
    Icon for Helper II rankHelper II
    5 years ago

    Hi 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

    • PaulDBrown's avatar
      PaulDBrown
      Icon for Community Champion rankCommunity Champion
      5 years ago

      paulmorgan 

      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:

       

      • paulmorgan's avatar
        paulmorgan
        Icon for Helper II rankHelper II
        5 years ago

        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!