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.
Hello,
I have this example of 2 tables, where the first one is number of products sold per day.
The 2nd table is the number of products that we need to sell each day.
Date | Product | Sold |
16-10-2019 | P1 | 300 |
16-10-2019 | P1 | 150 |
16-10-2019 | P2 | 50 |
16-10-2019 | P2 | 100 |
17-10-2019 | P2 | 200 |
17-10-2019 | P3 | 100 |
Date | Product | Limit |
16-10-2019 | P1 | 500 |
16-10-2019 | P2 | 100 |
17-10-2019 | P2 | 300 |
17-10-2019 | P3 | 100 |
The image below shows what I want to achieve which is the Limit for each product by day so I can know if the product sales exceeded the limit or no :
How can I achieve this with the 'Line and clustered column chart'.
Thank you
Solved! Go to Solution.
@Anonymous
You can get something close to what you are looking for, though not very pretty (you can improve on it by naming the legend appropriately and playing around with the format pane to tweak the bars etc..):
or you can create a new chart showing the difference between sales and limit:
Here is the link to the PBI file:
Hope that helps
Proud to be a Super User!
Paul on Linkedin.
Hi @Anonymous Use the Below link, Ihvae created page 2 as per your requirment.
get Updated PBIX file on below link..
https://drive.google.com/open?id=1ExQnZIh64Epwkfwt9bOubSeKvbTEJjR8
Thank you but I alread tried that:
Here is the image showing the result :
click on graph :- arrow in frant of fields column name:- change to count(Distint)
If you are still unbale to find the option change your column type to NUMBER
Thank you for your help, but I am new in PowerBI and I cound't figure it out.
Here is the link to the pbix file if you can help.
https://drive.google.com/open?id=1X4G4EVHDvR6_AA58kOKyk8lbEHqwREGV
Hi @Anonymous Use the Below link, Ihvae created page 2 as per your requirment.
get Updated PBIX file on below link..
https://drive.google.com/open?id=1ExQnZIh64Epwkfwt9bOubSeKvbTEJjR8
@Anonymous @PaulDBrown
Both solutions are great.
Thank you guys for you time, I really appreciate it.
@Anonymous
You can get something close to what you are looking for, though not very pretty (you can improve on it by naming the legend appropriately and playing around with the format pane to tweak the bars etc..):
or you can create a new chart showing the difference between sales and limit:
Here is the link to the PBI file:
Hope that helps
Proud to be a Super User!
Paul on Linkedin.
Hey @Anonymous i have Updated your PBIX file.
Allow me to Update the PBIX on drive
OR
Share me EmailId so that i can send it to you.
Thank you very much.
I shared my email with you in private
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 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |