Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Xencemaa
Frequent Visitor

Button switch pages based on segment state

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

1 ACCEPTED SOLUTION

Hi @Xencemaa ,

 

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

5 REPLIES 5
MFelix
Super User
Super User

Hi @Xencemaa ,

 

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...


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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

Hi @Xencemaa ,

 

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Thank you very much!

Ritaf1983
Super User
Super User

Hi @Xencemaa 
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.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.