Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello.
I'm attempting to create a stacked are chart, that shows the cumulative contribution (area) of 3 categories on top of each other. One of the categeories has negative contribution (negative area) so it should sit below the y-axis, which it does in the chart, however it is not every visible. This is what it looks like, the bottom area should be a bright green.
In fact if I alter the shade area- area transparency it dissapears altogether.
But if reverse the stack order it is visible in the way i would like it to be. Just not in the order I'd like ideally!
This is what I want it to look like. I can sort of achieve the look I want by using the 'Area chart' visual. However the problem with this is that the 'Area chart' visual doesn't have the total labels (adding the total area), which is the main point this visual is trying to get across.
Any ideas on how to fix this, either by adding a total label to the area chart or configure the stacked area chart to not hide my green area?
Solved! Go to Solution.
Hi @DMPower
There are not many options to "play" with this kind of graph.
I think that the only thing that you can do to see all your areas is to change the lines without using shading at all + to add a clear 0 line.
It's essential to recognize that, from the standpoint of effective data visualization, a graph may not be the most efficient means of conveying data relationships. The brain expends considerable energy deciphering various dimensions, colors, trends, and the intricacies of stacked graphs. I suggest exploring alternatives such as smaller graphs or other visualization methods to facilitate better comprehension of the data relationships by users.
For example:
Link to the pbix with both versions
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @DMPower
There are not many options to "play" with this kind of graph.
I think that the only thing that you can do to see all your areas is to change the lines without using shading at all + to add a clear 0 line.
It's essential to recognize that, from the standpoint of effective data visualization, a graph may not be the most efficient means of conveying data relationships. The brain expends considerable energy deciphering various dimensions, colors, trends, and the intricacies of stacked graphs. I suggest exploring alternatives such as smaller graphs or other visualization methods to facilitate better comprehension of the data relationships by users.
For example:
Link to the pbix with both versions
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thanks for your reply, it's a good suggestion. Unfortunately for this case, this is a requested visual, but perhaps you're right, I will go back and ask if this might be the most appropriate visual, in any other case. I might opt for the 'area chart' as the next best thing for what they want
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |