Button switch pages based on segment state

[Anonymous]

Hi!

I was wondering if it's possible to make a button switch between pages based on the state of a segment. 

For instance: I have a segment that switches between 'USA' and 'China'. I have a button that opens up another page showing more information on a table (bigger, more detailed table). I want that button to open the page 'Table - China' when the segment has 'China' selected and open 'Table - USA' when 'USA' is selected on the segment.

Is that possible? Is there another way of achieving the same result?

Thanks,

Xencemaa

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
Check the option of drill through:

https://www.youtube.com/watch?v=BbplhqDCWOM

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

[MFelix]

Hi @Anonymous ,

For this you can make a measure that has the following syntax:

Page Change = "Table - " & SELECTEDVALUE(Table[Segment])

Then on the button action select the page navigation and use this measure on the FX button. Should give you a button based on the selected segment you choose.

https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specif...

[Anonymous]

How can I reference the segment in the measure? I do not have a column 'Segment'

[MFelix · Accepted solution]

Hi @Anonymous ,

Where is the Sgement coming from? is it a column a measure?

You just need to reference the column from where that USA/China values are coming from, i called it segment because it was the name you gave on your question.

[Anonymous]

Thank you very much!

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
Check the option of drill through:

https://www.youtube.com/watch?v=BbplhqDCWOM

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