Using multiple values as input for a filter

[tex628]

Hello, I'm currently having a major issue with a report that I'm developing.

The report is presenting product information using sources holding several hundred thousand products. The normal process for my end users are that they have a range of product ID's in an excel sheet that they need to analyze. This range might include 100 or a 1000 products.

Due to this our normal method is to arrange the product ID's in a long string like this: Product1;Product2;Product3;Product4;Product5; ... etc.

I can not locate any method for me to allow my users to filter for a range such as the example, does anyone have a solution for this problem? 

Best regards,

Johannes

[tex628 · Accepted solution]

An antislicer will sadly not do the trick in this case. Fortunatly i have found  a potential solution in a custom visualisation. I will get back to you regarding the result! 

Br,

Johannes

[DrewGoode · Accepted solution]

Hi,

I couldn't actually see the solution on this post even though it was marked as solved so in case anyone is looking, use this custom visualisation and it lets the user copy and paste multiple values into a slicer to alter the data:

Cheers,

Andrew

[v-piga-msft]

Hi @tex628,

If I undrstand your scenario correctly that you want to filter the Product ID and analyze the Product?

 Due to this our normal method is to arrange the product ID's in a long string like this: Product1;Product2;Product3;Product4;Product5; ... etc.

---

I'm not very clear about your data model, for your requirement, we may need to change your data model. If it is convenient, could you show some data sample which could reproduce your scenario?

Best Regards,

Cherry

[tex628]

Alright!

First of all i have to say that I cant post pictures of the actual data due to company policy. I made a simplified version with dummy data.

This is the data source

This is the table that the report is running from. It holds 1000 products with different kinds of information.

The view of the user

This is what the user will see. I'm not the user and the user will not have access to the data sources of the report.

This is an excel sheet

This is the normal use-case. The user has an excel sheet with maybe 30-100 products. They want to use the report to filter away all products except for those in the excel file and through that be able to view the relevant information.

It's also important to note that this process can occur several times each week with different products each time.

I hope this explains the scenario, if you have any further questions please feel free to ask! 

/ Johannes

[v-piga-msft]

Hi @tex628,

If I understand your scenario correctly that you create the slicer with the products in Excel sheet and you want to show the values excepted for the vaules in slicer?

---

This is the normal use-case. The user has an excel sheet with maybe 30-100 products. They want to use the report to filter away all products except for those in the excel file and through that be able to view the relevant information.

It's also important to note that this process can occur several times each week with different products each time.

---

For your first requirement, it seems that there is no option for us to get the values expected for the values in Slicer. We may could achieve it with samll data model, but your product data is large.

To achieve your requirement, it seems to be a little complex with dax, I have found a sample you could refer to.

For your second requirement, I suggest you could configure a schedule refresh for your dataset.

Best Regards,

Cherry

[tex628 · Accepted solution]

An antislicer will sadly not do the trick in this case. Fortunatly i have found  a potential solution in a custom visualisation. I will get back to you regarding the result! 

Br,

Johannes

[tex628]

I will show you on monday when i get back to work! 

But essentially there is one large table, 210 000 rows with a product ID on each row and further information in other columns.