Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |