Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good evening, All!
I have a table that has different work types: Epic, Feature, and Backlog. If a user selects an upper level work type, the lower levels (feature and backlog) filters accordingly. The idea works but I'm wondering if there's a better method than what I currently have. To test, here's my sample data:
Work Type | WorkID | ParentID | Title |
Epic | 10 | Project1 | |
Epic | 20 | Project2 | |
Feature | 3049 | 10 | Build Solution |
Feature | 8493 | 10 | Test Solution |
Feature | 4739 | 20 | Create Form |
Feature | 1938 | 20 | Project Handover |
Backlog | 1083 | 10 | Build Project Solution |
Backlog | 1038 | 10 | Finalize Changes |
Backlog | 9042 | 20 | Get Requirements for Form |
Backlog | 8885 | 20 | Give permissions |
Screen 1- this is look of the sequence
Screen 2- As you can see, if I choose an Epic, it would filter the features and backlogs that accompanies it.
Screen 3- To accomplish the feat I referenced the original data and created this elogated relationship stack
Here's the PBI if anyone wants to maybe take a stab at a better method:
https://1drv.ms/u/s!An8CCFsOzw0uaW3ygYOWidPBowY
And of course, thanks in advanced!
Solved! Go to Solution.
Hi @hnguy71,
check out the feature Drillthrough in Power BI. It allows you to navigate to different report pages while applying filters set on the previous report page. In the following video you can see more: Youtube Drillthrough
Hi @Nolock
Appreciate the post but that's really not what I'm after. I'm aware of the drillthrough feature but let's say I'm an excutive without Power BI knowledge looking at a dashboard he or she probably wouldn't know how to drillthrough or navigate in and out of it. The idea is to make selections cascade dynamically and to easily navigate the page.
nice! I'll look into it further! Definitely closer to what I'm thinking! Thank you!