Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, I have a main page for the report and two for drillthrough. I am using the following measure on the action of a button to navigate to different drill through pages if I select a visual with one measure or if I select another measure on another visual.
Risk id | Owner | Creation Date | Mitigation Date | Mitigated | description |
1 | owner 1 | 30/06/2022 | 31/12/2022 | Mitigated | descr1 |
2 | owner 2 | 30/06/2022 | Open | descr2 | |
3 | owner 3 | 30/06/2022 | 31/12/2022 | Mitigated | descr3 |
4 | owner 4 | 31/12/2022 | 30/06/2023 | Mitigated | descr4 |
5 | owner 5 | 31/12/2022 | 30/06/2023 | Mitigated | descr5 |
6 | owner 6 | 31/12/2022 | Open | descr6 | |
7 | owner 7 | 31/12/2022 | Open | descr7 | |
8 | owner 8 | 30/06/2023 | Open | descr8 |
I am trying this measure:
@Sonnet I hope this helps you!!Thank You!!
Drillthrough filter =
VAR SelectedMeasure =
SELECTEDVALUE('Risk'[Selected Measure])
RETURN
SWITCH (
SelectedMeasure,
"Mitigated Risks", "Page 5",
"Total Open Risks", "Page 4",
""
)
Thank you for your help. When I use your measure, the SelectedValue function wants a column. You use '
'Risk'[Selected Measure]
what is 'Selected Measure'?
Meanwhile, I am trying to play with your measure, trying to find a working way.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |