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.
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?
Solved! Go to 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
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
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |