Different drill-through pages based on Category Name selected.

[Rdarshana]

Hello,

I have a unique requirement for drill-throughs in Power BI. 

I have a parent page that displays measures based on Category Name. 
So I made use of the KPI visual, that displays different measures based on Category Name (KPI block was one of the main requirements).

Now, when users click on the drill-through link for a given category name, the drill-through page should display different visuals based on the category name. 
The drill-through page that we created, contains 3 bookmarks - each acting as a tab within the drill-through page. Each bookmark contains different visuals. 

Based on the requirements, when user clicks on Category Name A, it will go to a drill-through page displaying three bookmarks. - 
BookMark A (sourced from common table 1 - same visuals)
BookMark B (sourced from category name A specific table 2)
BookMark C (sources from category name B specific table 3)

When User clicks on Category Name B, it will go to a drill-through page displaying three bookmarks - 
BookMark A (sourced from common table 1 - same visuals)
BookMark B (sourced from category name A specific table 2 - but different visuals - such as display two charts)
BookMark C (sources from category name B specific table 3)

How can this be achieved?

[v-xinc-msft]

Hi @Rdarshana ,

Did the reply offered help you solve the problem, if it helps, you can consider to accept it as a solution so that more user can refer to, or if you have other problems, you can offer some information so that can provide more suggestion for you.

Best regards,

Lucy Chen

[Kedar_Pande]

@Rdarshana 

1. Create a drill-through page with a Category Name filter to capture the selected category.
2. Create 3 bookmarks (Bookmark A, B, C) with visuals for each category.
   Use Selection Pane to show/hide visuals based on Category Name.
3. Create a measure to control visibility:
   ShowBookmarkB = IF(SELECTEDVALUE('Category Table'[Category Name]) = "A", 1, 0)
   Repeat for other bookmarks.
   
   
4. Apply the visibility measure as a filter on each visual.
5. Set up drill-through links from the parent page using Category Name.

💡 If this helped, please give Kudos 👍 or mark it as a Solution ✅.
Best regards,
Kedar
🌐 Connect on LinkedIn

[vanessafvg]

you wont be able to do separate drill through based on the same field, the only way to achieve that is to have the categories as separate columns.  Drillthrough is based on the column name.  You could potentially create 3 drill through pages and let the user select which one to go to from the column. 

[Rdarshana]

@vanessafvg 
Thank you for your response. 

Creating different columns with category name is not an option. This may require an update to the backend table. 

Is there anything else that could be done? May be add a button to the KPI card or some other form of drill-through that will work.
The issue we are seeing with using drill-through pages with bookmarks is that either 1 or 2 of the bookmarks (or tabs) contain data from the same table. So, one thing we found out was creating different measures for each drill-through page. 
So, for Category A will have measures with Category A related, and Category B will have measures with Category B related.