Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHow 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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you very much!
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.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |