Disable drillthrough to certain detail pages

[phoisan]

Hi,

I have a master page and it able to drillthrough to few detail page 1, detail page 2 and detail page 3 by click on the product Id.

Product ID

B00001

A00002

B00003

A00004

I want Product ID B00001 and B00003 able drillthrough to detail page 1 and page 3, Product ID A00002 and A00004 only able drillthrough to detail page 2.

Is it possible to do that in power bi?

[v-xuding-msft · Accepted solution]

Hi @phoisan ,

You could use the drill-through button.  I create a sample, you could reference it to have a try.

Selection = SELECTEDVALUE('Table'[Product ID])

A00002 = 
If([Selection]=="A00002" || [Selection] = "A00004", "A00002", "See Details")

B00001 = 
If([Selection]=="B00001" , "B00001", "See Details")

B00003 = 
If([Selection]=="B00003" , "B00003", "See Details")

Reference:

Create a drill-through button in Power BI 

[phoisan]

Briliant, did the job! Thank you for your reponse. I'm new to Power BI and  I don't know that have such features in Power BI

[amitchandak]

@phoisan , Refer if the Enhancement in may 2020 can help you

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/#_Cond_dest_drill