Read values ​​from filter (Mass Filter Slicer)

[Martin2024]

Hello everyone,

is it possible to read the values ​​that were entered into the Mass Filter Slicer?

If not, you can somehow read the values ​​that are displayed in the filter icon for a table?

What I want to achieve in the end is to show the user the values ​​where there were no hits.

Example:

User-Imput in Mass Filter Slicer

12345

23456

3456

Hit in the data table

12345

23456

Display in a text field or card visual

No Data for 3456

Is this even possible in Power Bi?

Thank you for your support and best regards

Martin

[MFelix]

Hi @Martin2024 ,

I believe this is not possible since the DAX calculations are based on the context of the data and not on the text values that you write in your visualizations, in this case the Mass Slicer.

For this you would need for example to use Deneb to create a custom visual that would allow you to add the filter and have the calculation for each line of the written data. But not sure if this is possible also.

[Martin2024]

Hi @MFelix ,

many thanks for your response. Unfortunately, I had this assumption too, but I was hoping that you could still get the information somehow, since it is displayed with the filter symbol on the table.

Maybe someone else has another idea on how to implement my plan?

I wish everyone a merry Christmas.

Best regards
Martin

[Anonymous · Accepted solution]

Thanks for the reply from MFelix , please allow me to provide another insight:

Hi, @Martin2024 
Thanks for reaching out to the Microsoft fabric community forum.

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

1.Firstly, I created the following test data:

2.Secondly, I created the following calculated table to be used as a Mass Filter Slicer:

Table = VALUES('data table'[date])

Please ensure that no relationships are established between the new table and the original table:

3.Next, I created the following measures:

Measure = IF(MAX('data table'[date]) IN VALUES('Table'[date]),0,1)

4.And applied them to the visual objects:

5.Here's my final result, which I hope meets your requirements.

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.

[Oscar1991]

Hello in my case this is not a solution, my issue is if the data base only has 12345 & 23456, I need the mass filter to check the input and if the user inputs is 333, to return that 333 is not found on database, and counst the errors, or the no hits in database

[MFelix]

Hi @Oscar1991 ,

Has I refered previously to my konwledge you cannot get the values written in a filter, slicer, ... into a card since you can only access the data in the columns, altough the values are taken into the visual itself and you can see it in the Filter Icon in the visual I believe that this is based on the engine of Power BI and Vertipaq and you cannot access that data directly.