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.
I am trying to compare multiple months data for count of placements. I was able to achieve this with composite models, but they won't publish to PBI. I have put my monthly files into groups so that they can be compared on one viz. I have created a total sheet comprised of all months to serve as a universal X-axis.
To create my relationships, I am using a Many to One with a Single Cross Directional Filter by connecting through implemented index columns. When I create the viz, they seemingly look correct but are off by 2-8 numbers in the count?
UPDATE: I need to filter each placement by the county for each month (see bottom picture), which is why i split the tables separately and created groups for them in my edit queries. Any advice on how to create this model would be appreciated. I have included a photo below of the viz I developed using Composite Models, but again I am trying to create a dashboard for my boss, which is not currently permitted with PBI.
Solved! Go to Solution.
Would need more information like sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But, honestly, it seems a little weird to me to have your data separated out into separate tables for each month versus just having a single table with a month column.
Would need more information like sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But, honestly, it seems a little weird to me to have your data separated out into separate tables for each month versus just having a single table with a month column.
You were right. I just needed to utilize the months filter by county instead of each one individually. Thanks for pointing me in the right direction
Hi @bw70316
It seems you've got the solution. If it is, please mark the helpful reply as solution. If not, please share some data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here.
Regards,
Cherie
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 |
---|---|
112 | |
97 | |
83 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |