The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello everyone,
Month | Year | Company | Country | Burgers sold | Buns | Steaks | Cheese | Pickle |
1 | 2016 | X | FRA | 5920 | 5920 | 5920 | 5328 | 4144 |
2 | 2016 | X | FRA | 6343 | 6343 | 6343 | 5709 | 4440 |
3 | 2016 | X | FRA | 2439 | 2439 | 2439 | 2195 | 1707 |
4 | 2016 | X | FRA | 6534 | 6534 | 6534 | 5881 | 4574 |
5 | 2016 | X | FRA | 7762 | 7762 | 7762 | 6986 | 5433 |
6 | 2016 | X | FRA | 2346 | 2346 | 2346 | 2111 | 1642 |
So basically, I want to show that for 5920 burgers sold in 01/2016, 5236 and 4144 cheese have been used.
The thing is that I have a pie chart (link between 2 tables) with my suppliers and, as we do not receive bill from them every month, Power BI believes that any cheese or pickles have been used. So I'd like to know if it is possible.
Thanks
Solved! Go to Solution.
I've responded to your other post as well.
Is your problem that the pie chart isn't giving you the desired result? I'm a little confused as to what your problem is.
I've responded to your other post as well.
Is your problem that the pie chart isn't giving you the desired result? I'm a little confused as to what your problem is.