show dynamic pages based on table selection from filter

[Anonymous]

Hi, I'm new to this. I want To show dynamic pages based on table selection .

Eg : Table 1

Id	Address
1	abc
2	pqr

Table 2

Id	Name	Age
2	abc	10
3	mn	11

on dashboard on selection of any table , data should de shown for that particular table like

If table 1 is selected then only its data should be shown.

Also, how to add table names in a filter.

Any help will be thankfull.

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Thanks for reaching out to us.

One idea, try this measure,  and put it into visual-level filter

filter = 
VAR _t= SELECTEDVALUE('FILTER'[NAME])
return
SWITCH(TRUE(),
"TABLE1" = _t,1,
"TABLE2" = _t,2)

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Anonymous Are you trying to say when you select a table in the Fields pane only it's information is shown or ?? You could accomplish what you want (well, I don't really understand what you want) but you could accomplish what you sort of describe by using buttons and bookmarks to hide and show visuals.