The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I'm new to PowerBI. I'm probably not doing this the right or the most efficient way, but I have to create various dashboards that provide Company Pursuit data during set time periods (e.g., Quarterly, monthly, etc.) such as:
My raw data includes hundreds of Company Pursuits with more than 1,000 Team Members from over 15 Industries.
Most Companies have more than one team member all of whom may either be from the same industry, different industries, or some from the same and others from different unique industries. As outlined in the list above, I have to create a dashboard with all cumulative data and then, another where they can see data for each Industry without Pursuits being counted multiple times for those with multiple team members, again, some of whom also belong to the same industry.
I've been able to create 1.B from the above list without duplicates included. I was also able to create 1.A.a-e originally, but it required a ton of data work where I had to spend a ton of time creating new columns and got so wrapped up with that mess that I don't even know how originally created those things without duplicates being counted.
I've tried splitting multi-value columns to different rows, different columns, and a combination of the two alongside a relationship table containing each Team Member and their cooresponding Industry, but it's too convoluted and each Pursuit is being counted multiple times in the totals or they appear multiple times in a dashboard table listing Pursuits for each applicable Industry.
What's the best way to handle the columns with multiple values, some with multiple relationships, so I can filter according to Industry without duplicate Company Pursuits appearing in the dashboards? I thought I could create a multi-value column with the cooresponding Industries and then another one based on that column that only displays unique values. Thoughts other than needing to do far more PowerBI lessons? Any and all guidance is appreciated!
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
38 | |
21 | |
20 | |
16 | |
13 |