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.
So I have the following example dataset
Project | revenue | margin | margin % | work type | Practice | Work Type | |
A | 100 | 99 | 99% | 1a | 1 | 1a | |
A | 100 | 1 | 1% | 1a | 1 | 1b | |
A | 50 | 50 | 100% | 2b | 1 | 1c | |
B | 33 | 22 | 67% | 1a | 2 | 2a | |
B | 90 | 89 | 99% | 1a | 2 | 2b | |
B | 100 | 10 | 10% | 1b | 2 | 2c | |
B | 40 | 11 | 28% | 2c |
Where the project table and worktype tables are separate. They are linked by the key called work type. I am running into a problem where I filter projects for a specific practice, it filters the resulting table for the parts of the projects that fit that specific practice, rather than the entire project. So if I filter for practice 1, it only shows the portion of project A that relates to practice 1 rather than the entire project. Is there any way to set it up such that this region slicer will show all projects that contain a specific practice rather than the portions of that project that are in the given practice?
Secondly, and related to this problem, I am trying to find projects who, in total margin %, are <10% or >90%. However, due to this setup, it only looks line by line and sees projects whose margin is <10% or >90% within a given worktype. So when I set up a filter for <10% or >90%, it only filters for parts of the project whose margin fit those characteristics. I tried a calculation for this but it is not working...
here is what I tried:
Solved! Go to Solution.
I'm afriad this couldn't be achieved, slicer will filter other visuals if you don't disable the interaction between slicer and other visuals. And slicer also doesn't have such feature like highlighting the filtered rows while keep the entire data.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@sjrrkb123 your first is not clear, if you are filtering the project, it should show all the work types from the tables? Can you share how you are using it? Share the relationship diagram.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k Sorry if I was not clear. I have updated the description but I will explain further here.
A given project can have 1 or many practices. Each practice can have 1 or many work types. So on a given project, there may be many practices each with multiple work types. I have a slicer for practices that, in its current form, filters the table visual in a manner I do not want. When I select Practice 1 and look at project A, I only see the first two line items as they are relating to practice 1. I want the practice slicer to highlight projects that have practice 1 but still display the entirety of the project.
So basically what happens after I hit Practice 1 in the slicer, the only thing I see in the visual is the following rows.
A | 100 | 99 | 99% | 1a |
A | 100 | 1 | 1% | 1a |
Is there any way to make the slicer show the entirety of the project, rather than just the portions that are in practice 1.
I'm afriad this couldn't be achieved, slicer will filter other visuals if you don't disable the interaction between slicer and other visuals. And slicer also doesn't have such feature like highlighting the filtered rows while keep the entire data.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |