Forum Discussion
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 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
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.
5 Replies
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.
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
MartinThanks 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.
