Forum Discussion

taskob's avatar
taskob
Frequent Visitor
1 year ago
Solved

ListName from parameter

Hi All, I would like to use a Parameter (List_Param) instead of hardcoding the name of my list to filter out some of the rows from several tables in the model. #"Remove Rows" = Table.SelectRows(#"...
Need Help
  • dufoq3's avatar
    dufoq3
    1 year ago

    You are right taskob, but you can do it this way (it works also in Power BI)

     

    I've hardcoded your lists into a table. See attached .pbix file.

dufoq3's avatar
dufoq3
Icon for Community Champion rankCommunity Champion
1 year ago

Hi taskob, it is possible, but we don't know how do you store your lists for such parameter. Do you store them as a separate queries? 

 

You can do it this way for example. Check attached .xlsx file!

  • taskob's avatar
    taskob
    Frequent Visitor
    1 year ago

    I see dufoq3.  My version seems to work in Excel too (see attached) , but i need it to work in Power BI Desktop and Cloud too....
    List_param.xlsx  

    • dufoq3's avatar
      dufoq3
      Icon for Community Champion rankCommunity Champion
      1 year ago

      It works the same in Power BI Desktop. 

       

       

      • taskob's avatar
        taskob
        Frequent Visitor
        1 year ago

        If you list the data from Element_values in a visualisation, it works for you? For me it's ok in Query editor, but no data in the visualisation.