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 Guys!
I have the next example data:
Account Name Value
1105 cash 500
110501 cash2 100
110502 cash3 300
110503 cash4 100
1110 banks 300
111001 banks2 100
111002 banks3 100
111003 banks4 100
I create a table report that shows only the "mother cod" (the 4 digits accounts and its called mother because it adds all the values from the sons, the 6 digits accounts) and the result was:
Account Name Value
1105 cash 500
1110 banks 300
I want to create a Drilltrought page that show other info of the account, including the sons. So for example, if I make right click in the CASH account on the previous data table, and go to the drilltrought, I want to appear a data table like this:
Account Name Value
110501 cash2 100
110502 cash3 300
110503 cash4 100
I don't know if this is possible but I really hope it can.
Thanks in advance,
Solved! Go to Solution.
Hi @juandroid,
It's possible in Power BI desktop September version, but you need to optimize your sample data firstly. The parent account 1105, 1110 need to be in a separate column like below:
Then you can create a Drillthrough report page, drag the Parent column to Drillthrough filters pane. Create another report page named Main, when you right click the 1105 and select Drillthrough, it will drill through to the Drillthrough report page and filter data. You can download the attached pbix to have a look.
Reference:
Use drillthrough in Power BI Desktop
Best Regards,
Qiuyun Yu
Hi @juandroid,
It's possible in Power BI desktop September version, but you need to optimize your sample data firstly. The parent account 1105, 1110 need to be in a separate column like below:
Then you can create a Drillthrough report page, drag the Parent column to Drillthrough filters pane. Create another report page named Main, when you right click the 1105 and select Drillthrough, it will drill through to the Drillthrough report page and filter data. You can download the attached pbix to have a look.
Reference:
Use drillthrough in Power BI Desktop
Best Regards,
Qiuyun Yu
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |