Different Cumulative Totals on same visual

Merchy2401 · ‎02-27-2018

Hi,

I have two query tables, one that shows sales targets by sector, by Month and a separate table that shows potential sales opportunities by sector, by month...

I have created a TotalYTD measure which when shown asa individual visuals work perfectly well & I can either have it ads a data table or a line/bar chart & they accumulate nicely.

However, I want to show both numbers on thesame visual (Bar & line graph) so that I can show the potential sales opportunities (as a stacked bar) & see how far away they are from the cumulative total (as a line)

When I do this, the potential sales accumulate as they should, but the target remains as the individual month values (ie they dont cumulate)

even if I use the same date column to drive my TOTALYTD calculation it has the same result..

any pointers would be great 🐵

v-jiascu-msft · ‎02-28-2018

Hi @Merchy2401,

Please share a dummy sample.

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k · ‎02-27-2018

Can you share the visual you are trying to achieve? And if possible share your pbix file (remove any sensitive data), and will see what can be done.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.