Stacked Bar/Line chart not displaying or summarizing properly

Question

Relatively new Power BI user seeking assistance.
I am comparing water supply to demand at several locations in a watershed. I can properly filter supply and demand by location of interest, and properly display the supply or demand individually. However when i try to combine the two, the summarizing or display is not correct.
In the attached image, Location of Interest is in top right, Demand is top left, Supply is bottom left. The middle and lower right visuals are 2 attempts to combine the charts at left using the Stacked Bar/line visual. When i use the date from the Supply data (middle right), supply appears correctly, but demand seems to be averaging over the year. Conversely, in the lower right, when i use the date from the demand data, demands appear properly, but supply appears to be averaged over the year. I have tried all of the summarization options in the Visualization pane drop down.
Any suggestions on how to make the combo chart show the data as displayed in the idividual charts at left would be greatly appreciated!

dedelman_clng · Answer

It looks like you're trying to graph 2 sets of data (Flow, unstacked_demand) that don't have a relationship with each other. The data model in your example report is very confusing because it is many-to-many relationships all around.&nbsp;What you should be aiming for is having a Date table, and then creating a relationship with those data tables with dates (Flow, unstacked_demand).&nbsp; You can then use the date column in your Date table as the axis, and you'll be able to associate Flow and unstacked_demand together.&nbsp; Right now, Flow doesn't know about unstacked_demand's date column, nor vice versa.&nbsp;One other thing to note is that one set of data seems to be continuous (Flow; value every day) while the other is categorical (unstacked_demand; one value per month).&nbsp; Those may not play well together on one graph, as either the monthly data will appear as very tiny line, or the daily data will show as a the value on the same day as the monthly data. The latter behavior is shown below (once I removed some model relationships to allow unranked_demand to be linked to the date table):&nbsp;Let us know some more information on what the data is and why the relationship are how they are and we may be able to point you further in the right direction.&nbsp;Hope this helpsDavid&nbsp;

v-easonf-msft · Answer

Hi ,&nbsp;Anonymous&nbsp;The attached picture is too small to be clearly recognized, can you choose a large size for display ?&nbsp;Best Regards,Community Support Team _ Eason&nbsp;

anonymous · Answer

v-easonf-msft&nbsp;, please let me know if i can provide other useful info- thanks for looking!&nbsp;for clarity Flow=Supply, and AF=demand; the first image is unfiltered and the absolute values shown (Supply vs demand) will be somewhat different.&nbsp;&nbsp;&nbsp;This image uses a Location of interest (Gage) to filter, and the values should be much closer/overlap each other.&nbsp;&nbsp;&nbsp;

v-easonf-msft · Answer

Hi ,&nbsp;Anonymous&nbsp;Can you share a&nbsp; sample pbix file&nbsp; &nbsp;which would help tremendously.You are unlikely to reach a solution in community forum for this kind of unknown issue that we cannot test and reproduce without a sample file.You also can&nbsp; create a support ticket or even ask for a phone call support in the ticket.&nbsp;Best Regards,Community Support Team _ Eason

anonymous · Answer

Hi,&nbsp;v-easonf-msft&nbsp;I have uploaded the file at the link below. Thanks for looking.https://drive.google.com/file/d/1DLfzHuNI3f3HTv6npaRpSYk4jilo-th1/view?usp=sharing&nbsp;

Forum Discussion

Stacked Bar/Line chart not displaying or summarizing properly

9 Replies

Related content

Stacked bar with line

Parameter in summarize

Don't Summarize....still summarizes...?

Average horizontal Line across the Bar chart

Line Break in X-Axis of Bar Chart