Forum Discussion
Read values from filter (Mass Filter Slicer)
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.
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.
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
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.
