Forum Discussion
Line and stacked column chart help
Hello all. I'm trying to create a line and stacked column chart and am having issues getting it working correctly. The chart needs to show a running total, broken down by week, and display the totals for said week. This part I have working via the measure below. The second part is that I need to have it color coded based on a yes/no column. When I apply this column to 'column series', I get incorrect numbers.
Client Count =
CALCULATE(
DISTINCTCOUNT('MyTable'[ClientID]),
FILTER(ALL('MyTable'),
'MyTable'[Date Submitted] <= MAX('MyTable'[Date Submitted])))
For example, My last column shows 7458 as the total. When I add the yes/no column to column servies, I get a 50-50 split in the color, and the number reported for yes is 7458, and for no the number shown is 7458 as well.
I have several other line and stacked column charts where the color coding is working fine and two that arent, both using a running total so I assume that's where the problem is, but I haven't been able to figure out how to correct it.
I'm fairly new to Power BI as I'm coming from Tableau, where I had this working fine. Unfortunately, I need to get it all moved to PBI and am still trying to figure it out. Any help would be appreciated.
9 Replies
Hi Anonymous ,
the problem is that ALL ignores all filters on MyTable.
Use a data table to ignore the filter only on the date.
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.Hi Anonymous ,
I am not clear about your problem, if possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
There's too much private data to realistically mask it all. Instead, I've created sample data from scratch and replicate the problem I'm having. At the link below you'll find the data in an Excel file and a PBIX with two sheets. One showing the data with running total, no column series. The second showing running total, with the 'expedited' column. Total data is 100 items, and in the second page, it shows 100 for yes and 100 for no. Same problem I'm having with the real data.
