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 have two tables with the same structure and data. My end goal is to divide a report into two sides and then compare the different margin results on one line graph. I would like to filter each side of the report with its own set of filters. I have gotten this far and have two separate views of margin. Margin 1 and Margin 2.
The margin for contract group I'm tracking starts in separate months so my hope is to plot these all on a line graph using month 0-24. For this I created a third table called Relative Months and have that going from 0-24. This table is now joined to the two others.
I have done a lot of digging and tried a few things but have not been able to crack this one. Would appreciate any help!
If you have a shared Relative Months table going to two separate Margin tables, what issue/error are you seeing. If you use the shared table/column for the axis, and have two separate measures (one for each Margin) in the line chart, it should work and you should be able to use slicers from columns from each table that would not affect the other margin. What are you seeing?
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |