Forum Discussion

mtmali20's avatar
mtmali20
New Member
1 year ago

How to View Data Inputs NOT Found

Greetings, 

I have a Power BI table report where users often need to filter a column by many values (sometimes hundreds). 

 

To address this, I've added the Power BI certified visual 'Mass Filter' by Insiders.coop ('Product Number' in screenshot). It works great for filtering the data table, except users also need to know which values they enter into there are not found.

 

Is there any way to reference the user input through a DAX query? The 'Mass Filter' visual is somehow taking the user input, adding it to a table/list, then making an inner join to the table's column, but I don't know how to reference that background 'list'.

 

I appreciate any help I can get!

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Have the user input stored as a CSV file on a sharepoint.  Include that CSV source in your semantic model. Use Power Automate to initiate a semantic model refresh whenever that file gets modified.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, mtmali20 

    May I ask if you have tried the method provided by lbendlin ? Is the method he provided applicable to you?

     

    If the problem is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

    If not, please provide more details about the problem you are experiencing and we will do our best to solve the problem you are experiencing.

     

     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.