Show data in template using parametrised filter on table name

[Anonymous]

I  have the following situation.  In my report, there are multiple tables:

testResults1 = {5.01, 5.00, 5.03, 4.99, ...}

testResults2 = {4.97, ..... }

testResults3 = {..}

I'd like to create a template which is able to visualize the data from one table at a time.

Then it should be possible to copy that template and assign one of the tables to be visualized. Preferably in an easy way such as picking the table from a drop down list. I don't want the viewer to be able to change that selection, so a dynamic filter (slicer?) is not an option. Probably one can do this by using parameters, but I'v only found articles on filtering columns using parameters.

Does anyone know how to achieve this?

Thanks in advance,

Claude

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may check the posts below.

• https://community.powerbi.com/t5/Desktop/Syntax-for-referring-to-a-Table-indirectly-as-a-Source/m-p/510179#M238403
• https://community.powerbi.com/t5/Desktop/Loading-M-Code-From-Text-Files-fails-with-reference-set/m-p/12836#M3094