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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
archuleta28
Resolver I
Resolver I

Drill through

Hi! Hope you are doing well!

 

I am stuck at one specific implementation and need your guidance for that!

 

ProductsSalesProfit %
A25000   65%
B1000 2%
C6700 20%
D16000 40%

 

So the requirement is to add a functionality to the above table where- if a user wants to see further analysis of a product lets say Product "B" based on the profit/sales then they should be able to click on that specific record and the naviagtion should take user to next page where only the further details for Product "B" is mentioned. Basically a drill through kind of an idea but for each of the records, functionality should work similarly, for that selected product. 

 

Please guide me how can I achieve this?

 

Thanking you in advance for any help! 🙂

1 ACCEPTED SOLUTION

...the naviagtion should take user to next page where only the further details for Product "B" is mentioned. Basically a drill through kind of an idea but for each of the records, functionality should work similarly, for that selected product. 

Go to desination page 

  1. From the format Tab Expand 'Page informtaion'
  2. Change 'Page Type' 
  3. Click Add data to select your Products field

othy_bi_0-1690287067194.png

 

So the requirement is to add a functionality to the above table where- if a user wants to see further analysis of a product lets say Product "B" based on the profit/sales then they should be able to click on that specific record and ....

Right click a record of your choice in the first page then Drill through to your destination page

 

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

View solution in original post

4 REPLIES 4
DataVitalizer
Super User
Super User


Hi @archuleta28 

Would you have unique values in the column Products?

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

Hi, yes I do have unique values in Product column

...the naviagtion should take user to next page where only the further details for Product "B" is mentioned. Basically a drill through kind of an idea but for each of the records, functionality should work similarly, for that selected product. 

Go to desination page 

  1. From the format Tab Expand 'Page informtaion'
  2. Change 'Page Type' 
  3. Click Add data to select your Products field

othy_bi_0-1690287067194.png

 

So the requirement is to add a functionality to the above table where- if a user wants to see further analysis of a product lets say Product "B" based on the profit/sales then they should be able to click on that specific record and ....

Right click a record of your choice in the first page then Drill through to your destination page

 

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

Thnak you, let me look into this and try it. Your help is much appreciated!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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