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.

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 😉