cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AtikurRahman
Frequent Visitor

SmartFilterBySQLBI

Hi,

 

Can someone assist with an issue I am having with the 'SmartFilterBySQLBI' visual?

 

Using the visual works however I want to limit the amount of options which are conveyed to the user from the dropdown list. On selecting a number of my choice for the dropdown list, as well as limiting the user to selecting a certain amount of things from the dropdown list, nothing changes.

 

The default is 10 on the dropdown list and 'auto' on selectable.

I have changed the parameters to dropdown = 7 and the selectable = 7.

 

After this I would go back to my visual within the report and test the changes, but nothing has happened. The visual still conveys a high number from dropdown list and selectable amounts do not work either. This is by far the most laggiest visual I have worked with within Power BI. It's slow, non-responsive at times and quite frankly very limiting. I like the idea of engaging the user to enter data into the search bar or using the dropdown list but it doesn't even work?

 

Any advice would be appreciated,

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Re: SmartFilterBySQLBI

Hi @AtikurRahman,

There is no other method unless we restrict rows of the column to 7 in data source.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Microsoft
Microsoft

Re: SmartFilterBySQLBI

Hi @AtikurRahman,

Based on my test, when I set the Max dropdown rows to 7, it doesn’t work as expected. However, when I set max selectable items to 2, I cannot select more than 2 items in the 'SmartFilterBySQLBI' visual, please check this link to get more details about how the “max selectable items” option works.

In addition, as the  'SmartFilterBySQLBI'  visual is published by third-party organization, regarding to the Max dropdown rows issue in it, please directly contact the author. In this link, you can send an email to the author by clicking “Contact Author”.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
AtikurRahman
Frequent Visitor

Re: SmartFilterBySQLBI

Hello @v-yuezhe-msft,

 

Likewise I can also only manage to work the 'max selectable items' however the desired amount for the dropdown list does not work.

 

Thanks for providing the resources for more information on this and I will surely contact the Author for this visual with feedback.

 

Atikur

AtikurRahman
Frequent Visitor

Re: SmartFilterBySQLBI

@v-yuezhe-msft

 

Is ther any way in which we can apply a logic in which the visual will always only dropdown/select 7?

 

If so, then I could work with that for the time being.

Thanks,

Atikur

Microsoft
Microsoft

Re: SmartFilterBySQLBI

Hi @AtikurRahman,

There is no other method unless we restrict rows of the column to 7 in data source.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors