Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
danie_figueroa
Frequent Visitor

area chart starts at 0 doesn't work

Hello community, I'm something new and I don't know how to approach this, as the title says I have a graph that has a total value per month as seen in the image,

danie_figueroa_0-1677252992096.png

 

but I want it to start from 0 and not from the minimum registered value of the total.
I have been reading some comments and solutions but they have not worked for me, for example when I go to the format options and put 0 as min, the graph does not suffer any change

danie_figueroa_1-1677253037411.png

 

What I can do?

3 REPLIES 3
lbendlin
Super User
Super User

Your graph's Y axis seems to be correctly starting at 0 after you made the configuration change.  Is that not your expected result?  Are you maybe looking for a stacked area chart or a ribbon chart?

I understand what you mean, since the y-axis starts at 0 in the graph, but what I was looking for is that for each line (representing each year itself) start from 0, and not from the value calculated for the month of January. In this case, it would be understood as an accumulated graph, but only for the initial part, between 0 and the minimum value calculated for January.
As for an accumulated graph, I have one made but the same thing happens to me, it starts from the minimum calculated value and I cannot make the line go out of 0

danie_figueroa_0-1677501399557.png

 

Your granularity is on month level.  This assumes the value for January is representing the end of January.  Use more granular data (on day level) or redefine January as "beginning of January"

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.