Forum Discussion
Issue with Filter by List by Devscope Visual
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
- export a template of your dashboard (PBIT).
- Then you open the PBIT template file in 7zip or Winzip and find the 'FilterByList507A2DBEC31244C8AAABDE9BA541F723' folder within Reports>Custom Visuals.
- Extract the files within and repackage/zip them up as a new file ending in pbiviz (e.g. CustomVisual.pbiviz)
- Back in your PBIX file, in the Visualizations pane, select ... and then 'Import a visual from a file'
- 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.
Advocate IIFound an impartial solution - you can load the old version of the visual but Im not able to sync across pages yet.
You can download the old version here: Power BI Custom Visuals - Filter by List (pragmaticworks.com)
then going into File -> Options and Settings -> Options -> Current File ->Report Settings -> Develop a visual and click it so you can override the version. Import the old version of the slicer, on the pop up that asks whether to use appsource version click the one that says use local version
Advocate IIAMarks powerbizb77 mhammersness Anonymous
Any chance any of you have a later version of the visual, like a 2.0 version? If you share than maybe we can revert this functionality
- NorwaySasquatch
I was able to find a 2.0 version and loaded it successfully in PBI Desktop. I loaded it into two tabs, and sucessfully was able to sync it across tabs. All normal functionality was restored. However, after publishing to Report Server the slicer broke - instead showing 'this isnt available in this environment' aka it stopped working.
Crappy part is, even the paid version wont be supported in our PBI Report Server environment per this link License models for Power BI AppSource visuals - Power BI | Microsoft Learn, and Microsoft doesnt plan for this to ever be available. No license management.
Can you give link to 2.0 version. I want try on PBI service
- NorwaySasquatch
I dont think Im able to upload files from my work laptop. In the meantime, if you load this version to a page, it should allow you to test if it will error out post publishing. Power BI Custom Visuals - Filter by List (pragmaticworks.com)