Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

show dynamic pages based on table selection from filter

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

Eg : Table 1

     

IdAddress
1abc
2pqr

 

Table 2

     

Id NameAge
2abc10
3mn11

 

 

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.

Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    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.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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.

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    3 years ago

    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.