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. 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). The data model in your example report is very confusing because it is many-to-many relationships all around. It looks like you're trying to graph 2 sets of data (Flow, unstacked_demand) that don't have a relationship with each other.
#GOOGLE CHARTS STACK BARS FROM DIFFERENT LINES HOW TO#
I have tried all of the summarization options in the Visualization pane drop down.Īny suggestions on how to make the combo chart show the data as displayed in the idividual charts at left would be greatly appreciated! 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. When i use the date from the Supply data (middle right), supply appears correctly, but demand seems to be averaging over the year. The middle and lower right visuals are 2 attempts to combine the charts at left using the Stacked Bar/line visual. In the attached image, Location of Interest is in top right, Demand is top left, Supply is bottom left. However when i try to combine the two, the summarizing or display is not correct.
I can properly filter supply and demand by location of interest, and properly display the supply or demand individually. I am comparing water supply to demand at several locations in a watershed. Relatively new Power BI user seeking assistance.
0 kommentar(er)
