Forum Discussion
Stacked Bar/Line chart not displaying or summarizing properly
v-easonf-msft , please let me know if i can provide other useful info- thanks for looking!
for clarity Flow=Supply, and AF=demand; the first image is unfiltered and the absolute values shown (Supply vs demand) will be somewhat different.
This image uses a Location of interest (Gage) to filter, and the values should be much closer/overlap each other.
Community SupportHi , Anonymous
Can you share a sample pbix file 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 create a support ticket or even ask for a phone call support in the ticket.
Best Regards,
Community Support Team _ Eason
Hi, v-easonf-msft
I have uploaded the file at the link below. Thanks for looking.
https://drive.google.com/file/d/1DLfzHuNI3f3HTv6npaRpSYk4jilo-th1/view?usp=sharing
- dedelman_clng
Community Champion
Hi Anonymous -
On both graphs on the right, you can use a secondary y-axis to show line values separate from column values. On the formatting section, scroll to the bottom of "Y-axis"and you'll see "Show Secondary". Turn that on and you can have a completely independent axis for the line values.
Hope this helps,
David
Hi dedelman_clng , Thank you for the suggestion.
I have tried the secondary axis, however it does not change the summarization which appears to be the problem. I turned the secondary axis on in the example posted previously, and while the data now overlaps, the straight line in the right visual should look like the line in the left visual.
