cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ait-james
Frequent Visitor

Retrieve more data based to result of a measure (number data type)

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.

 

Aitjames_0-1637052450851.png

Thank you !

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @Ait-james ,

Do you consider syncing slicers.

I created some data:

Index table:

vyangliumsft_0-1637301611819.png

Order table:

vyangliumsft_1-1637301611821.png

Here are the steps you can follow:

1. In Page1, use [Index] as the slicer, and click View – Sync slicers.

vyangliumsft_2-1637301611825.png

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.

vyangliumsft_3-1637301611827.png

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.

vyangliumsft_4-1637301611828.png

 

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

View solution in original post

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @Ait-james ,

Do you consider syncing slicers.

I created some data:

Index table:

vyangliumsft_0-1637301611819.png

Order table:

vyangliumsft_1-1637301611821.png

Here are the steps you can follow:

1. In Page1, use [Index] as the slicer, and click View – Sync slicers.

vyangliumsft_2-1637301611825.png

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.

vyangliumsft_3-1637301611827.png

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.

vyangliumsft_4-1637301611828.png

 

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

View solution in original post

selimovd
Super User
Super User

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

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors