Forum Discussion
Drill through using inactive relationship
Hi Nabil20_24 ,
Just wanted to check if you had the opportunity to implement the solutions provided by the users?
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Hi, thanks a lot for your time and help! The solution provided doesn’t quite get the output I need.
I want to create a bar chart that shows the number of active and inactive clients side by side. I also want to have one drill-through page that contains the underlying data.
So, when I right-click on the active bar in the chart (to drill through), I want to see all the active clients in detail, including their name, location, join date, etc. Similarly, when I click on the inactive bar, I want to go to the same drill-through sheet and see all the inactive clients without having to create separate drill-through pages or data tables for each client status (active and inactive).
Hi Nabil20_24 ,
The chart shows active/ inactive users side by side.
If you right click on the bar you would be directed to a table that will show the details of that particular bar.
Below snap for reference-If you need some help on how to implement drill through feature, you can refer this link
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthroughHope this helps!
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.