Forum Discussion

powerbizb77's avatar
powerbizb77
Regular Visitor
2 years ago
Solved

Issue with Filter by List by Devscope Visual

There is a helpful visual I use to allow users to paste in a list to be filtered on. The visual name is “Filter by List by Devscope”. This has always worked perfectly. It still works normally for me,...
  • booyah2001's avatar
    2 years ago

    I found a solution that is currently working for me (I'm on PBIRS January 2023 version).  This youtube video got me pointed in the right direction:

     

    https://www.youtube.com/watch?v=mqDDgPDhSE4

     

    If you have a PBIX file with a previously working version of the FilterByList visual, you can

    1. export a template of your dashboard (PBIT). 
    2. Then you open the PBIT template file in 7zip or Winzip and find the 'FilterByList507A2DBEC31244C8AAABDE9BA541F723' folder within Reports>Custom Visuals. 
    3. Extract the files within and repackage/zip them up as a new file ending in pbiviz (e.g. CustomVisual.pbiviz)
    4. Back in your PBIX file, in the Visualizations pane, select ... and then 'Import a visual from a file'
    5. Select your newly packaged pbiviz file and you should get a messaage 'Import successful'

    Between steps 3 and 4, I did something that I'm not sure is necessary.  I read in this thread about the need to modify all references of a 'guid' variable throughout the files in the FilterByList folder.  I might've done overkill on this, but I'll try to explain. 

    • The folder inside the PBIT file was named 'FilterByList507A2DBEC31244C8AAABDE9BA541F723' so I appended that name with 'XX' to become 'FilterByList507A2DBEC31244C8AAABDE9BA541F723XX.'
    • Within the folder is a file 'package.json' - it contained a 'guid' variable and also another reference to FilterByList507A2DBEC31244C8AAABDE9BA541F723.  In both cases I appended the values with 'XX' 
    • Within the folder there is another folder 'resources' and a json file called 'FilterByList507A2DBEC31244C8AAABDE9BA541F723' I appended the 'XX' to that filename as well.
    • I opened that file and did a find/replace on all references to '507A2DBEC31244C8AAABDE9BA541F723' in order to append them with 'XX' - there were probably 5-10 of them.
    • I saved all those changes to the files before extracting/zipping them.

     

    Anyway, good luck and you can PM me if you need any help.