Forum Discussion

Martin2024's avatar
Martin2024
New Member
1 year ago
Solved

Read values ​​from filter (Mass Filter Slicer)

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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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's avatar
Oscar1991
Regular Visitor
1 year ago

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's avatar
MFelix
Super User
1 year ago

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.