Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hello community,
I would like to know please if it's possible to do these two things in Power BI.
Case 1 : How can retrieve the information of the 2 orders based to the result of the measure I created ?
Example of scenario -> When I click on the number "2" I will be redirected to another page who contain a table that will be populated with order information.
Case 2 : Display the order with high priority among the 2 orders.
Thank you !
Solved! Go to Solution.
Hi @Ait-james ,
Do you consider syncing slicers.
I created some data:
Index table:
Order table:
Here are the steps you can follow:
1. In Page1, use [Index] as the slicer, and click View – Sync slicers.
The same slicer will also appear in Page2 later, and the two slicers will communicate with each other
2. Create measure.
Flag =
var _select=SELECTEDVALUE('Index table'[Index])
return
IF(
MAX('Order table'[priority])<=_select,1,0)
3. Place Measure[Flag] in the Filter in Page2, set is =1, and apply filter.
4. Result:
When the click slicer in Page1 is 2, it will be synchronized to Page2, and the information of priority<=2 will be displayed.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Ait-james ,
Do you consider syncing slicers.
I created some data:
Index table:
Order table:
Here are the steps you can follow:
1. In Page1, use [Index] as the slicer, and click View – Sync slicers.
The same slicer will also appear in Page2 later, and the two slicers will communicate with each other
2. Create measure.
Flag =
var _select=SELECTEDVALUE('Index table'[Index])
return
IF(
MAX('Order table'[priority])<=_select,1,0)
3. Place Measure[Flag] in the Filter in Page2, set is =1, and apply filter.
4. Result:
When the click slicer in Page1 is 2, it will be synchronized to Page2, and the information of priority<=2 will be displayed.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hey @Ait-james ,
that should be possible with a drill through button:
Create a drillthrough button in Power BI - Power BI | Microsoft Docs
https://www.youtube.com/watch?v=4Qy-bksqExI
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
103 | |
63 | |
45 | |
37 | |
35 |