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
Community 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.

  • dufoq3's avatar
    dufoq3
    Community Champion
    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.

    • taskob's avatar
      taskob
      Frequent Visitor
      1 year ago

      Thank you!

      • dufoq3's avatar
        dufoq3
        Community Champion
        1 year ago

        You're welcome, enjoy 😉