Forum Discussion
Column chart, data, and drill through
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=ESap6ptV8fIIf 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!