Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
powerbizb77
New Member

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, but I had 2 users report issues with it this morning (June 4th, 2024).

 

Normally it looks like image1. 

The issue the users reported today is that it looks like image 2 and does not work. The users who reported this tried it on both Edge and Chrome and it was doing this on both.

What is the cause of this issue and what can be done to fix it?

 

Image 1:

Image1.png

 

Image 2:

Image2.png

1 ACCEPTED SOLUTION
booyah2001
Regular Visitor

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.

View solution in original post

39 REPLIES 39
havsgaard
Frequent Visitor

Extremely stupid moved by ... I dont know if it is MS or Devscope ... and push out an update affecting all released dashboards.


We have no intention of starting to pay a license all of a sudden to maintain functionality working fine for the past two years - now what ?

look for my post above. i linked to a stand alone version of the slicer that you can download from the devleoper.  we are scrambling to implement it in all of our reports but at least its a work around

I agree.  We now have to scramble to get this resolved in our production reports. I don't know how this basic functionality isn't a standard Microsoft visual type in the first place. Very frustrating. 

AMarks
Advocate I
Advocate I

great news!  I have been communicating with support and they are working on some bug fixes and possible licensing changes, but in the meantime they have made the old version of the slicer available for usage.  here is a snippet of my chat with them...

 

We will give you access to the old version so that you can use it internally in your reports. The only difference is the Internal Id so Power BI online does not automatically update to the newest version.
Please download it here - https://download.devscope.net/setups/FilterByList/FilterByListOnPrem.2.1.0.0.pbiviz

 

We are trying to roll back licensing, but we are dependent on Microsoft's validation process. 
So while the validation process takes place, anyone on the forum can use the link.

 

We are testing out how to implement this change.  from what we can tell, what you need to do is:

1) download and install the new "old" slicer 

2) change the existing slicer in your report to this new one

3) unsync this slicer from any existing tab in your report, and then resync the slicer

4) you may need to do some formatting cleanup

 

if you dont do #3 or 4, the synced slicers stay as the "new" version and dont get updated to the "old" one

 

good luck!

Adam

this is great news! Do we all have to contact them directly to get the old version back? 

nope. just download from that link in my post

AMarks
Advocate I
Advocate I

I think we need AS MANY PEOPLE AS POSSIBLE to email support@devscope.net

 

as them to

1) revert back to old version until they fix the bugs in the new version

2) release the old version as a free stand alone slicer

3) expand the number of values you can filter to in the free version.  even just from 20 to 100 would be such a huge impact

 

The problem there is the developer is only going to see such a campaign as an indication of greater demand, and is more likely to increase the price than it is to back down.

What I'm blown away by is that v1 was actually released under GNUv3, so is legally free software.  Microsoft forcing an upgrade from a version under GNU to a newer version under private copyright is a defacto theft of the commons, as there is no longer any way for anyone to use v1 legitimately despite it still existing.

I'm completely behind building a marketplace for good ideas to incentivise the improvement of the Power BI ecosystem.  But doing so via ensh1tification of preexisting GNU-released solutions to retroactively make a buck, that's not on.

booyah2001
Regular Visitor

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.

see below....  (and copied here).. developer provided a standalone version of the slicer you can download from them

 

We will give you access to the old version so that you can use it internally in your reports. The only difference is the Internal Id so Power BI online does not automatically update to the newest version.
Please download it here - https://download.devscope.net/setups/FilterByList/FilterByListOnPrem.2.1.0.0.pbiviz

 

We are trying to roll back licensing, but we are dependent on Microsoft's validation process. 
So while the validation process takes place, anyone on the forum can use the link.

Thanks alot , this solved the issue for now with publish reports with Jan-2024 version eport server

Thanks! This solution worked for me. 

The actions between steps 3 and 4 are crucial. It won't work without that. 

Tried the above steps, got error "File FilterByList....pbiviz isnt a valid custom visual. Will try again

I PM'd you

It is working in Power BI Desktop, but the moment I am publishing it to services, new version is automatically updated.

I think the extra steps I mentioned about modification of the 'guid' variable is supposed to prevent it from updating.  I am on PBIRS and not the full PBI cloud service, so I can't vouch for this solution in your setup.

this worked still after you published it to the Report Server? Thats where I was having issues previously.

Worked for me! PBI Report Server May 2023

Yes - still working on our production report server this morning

Rosalin_4050
Regular Visitor

Does anyone have the previous version ?

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.