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.
Hi everyone,
i am quite new to Power BI but already watched several training videos. Currently i am working on a Power BI report which will be embedded in SharePoint Online. One of the graphs shows Sales data (ytd) and planned sales for the year. My graph (s. below) shows only total values at the moment.
What i want to add is the percentage of actuals sales compared to the planned value -> (1600/9100)*100=17,58% How can i do this?
Thanks
Solved! Go to Solution.
Hi @Nitro ,
We can use the Line and stacked column chart visual to meet your requirement.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Nitro ,
We can use the following measure and set it to the percentage format to meet your requirement:
Measure = SUM(ActualTable[Sales])/SUMX(FILTER(ALL('ActualTable'),'ActualTable'[Period]="Plan"),[Sales])
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thank you for your reply. Is it also possible to still display the total numbers and in addition somehow also display the percentage at the same time?
Hi @Nitro ,
We can use the Line and stacked column chart visual to meet your requirement.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
107 | |
97 | |
75 | |
63 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |