Forum Discussion
Drill-Through using Column Names
daytonwinter TO make it work, you should Unpivot your data:
Transform Data -> Select Employee Column -> Right CLick -> Unpivot other columns
It will add two columns, attribute and value, rename these as you see fit.
Close and apply
Create a page with table visual and put attribute column in it, it will show all the training, add another page with employee and date column in it and in drill thru add ATTRIBUTE column
Go back to page 1, right click and it will show you 2nd page for drill thru and that's it. Read more about drill thru here Set up drillthrough in Power BI reports - Power BI | Microsoft Docs
✨ Follow us on LinkedIn and subscribe to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
daytonwinter TO make it work, you should Unpivot your data:
Transform Data -> Select Employee Column -> Right CLick -> Unpivot other columns
It will add two columns, attribute and value, rename these as you see fit.
Close and apply
Create a page with table visual and put attribute column in it, it will show all the training, add another page with employee and date column in it and in drill thru add ATTRIBUTE column
Go back to page 1, right click and it will show you 2nd page for drill thru and that's it. Read more about drill thru here Set up drillthrough in Power BI reports - Power BI | Microsoft Docs
✨ Follow us on LinkedIn and subscribe to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
This is exactly what I needed. Thanks!