The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Greetings all,
Hoping you can help with a problem I'm trying to tackle.
My data looks like this:
Data
And I need to develop a chart like this
Chart
I need the chart elements to drill through to detailed data that matches the ID (Name, etc).
Currently the chart is using measures to count the instance of the 6 categories, but that does not help with building the drill through.
Can anyone help with the best way forward?
Solved! Go to Solution.
Hi @AFinster
Since the drill needs to receive filter context, it cannot work with measures the way you have defined them.
You need to transform your pivot table into a flat, vertical table.
(This will also help with other analyses.)
Then, the drill will work as expected.
I attached the pbix you can follow my steps in PQ+ check the drill :
+ see the attached guide :
https://www.youtube.com/watch?v=ESap6ptV8fI
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @AFinster
Since the drill needs to receive filter context, it cannot work with measures the way you have defined them.
You need to transform your pivot table into a flat, vertical table.
(This will also help with other analyses.)
Then, the drill will work as expected.
I attached the pbix you can follow my steps in PQ+ check the drill :
+ see the attached guide :
https://www.youtube.com/watch?v=ESap6ptV8fI
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks Rita - greatly appreciated!