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,...
Need Help
  • booyah2001's avatar
    booyah2001
    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

HI,powerbizb77 

Regarding the issue you raised, my solution is as follows:

1.In order to reproduce your error scenario, I ran the following tests:

First I downloaded the visual object in the following version:

Here's the table I created:

The following is the test result I uploaded to the service:

According to my actual observation, there is no scene of your error.

2.The solutions we can give are:

First, you can check if the version of the custom view object you are using needs to be updated.

 

Second, you can also try to uninstall the view object again and then install it.

Finally, you can find more useful help information in support on the view object page.

Here is the link:

Contacts - dev>scope (devscope.net)

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • mhammersness's avatar
    mhammersness
    Frequent Visitor
    2 years ago

    The version you are showing here (2.0) is the previous (working) version that my organization was using previously. The update that was just pushed through in the last couple of days is now 3.0 and does not work AT ALL like prevously.  There appears to be some row limit to what you can paste into the filter or the users get an error with "upgrade" when trying to paste large lists in here.