Forum Discussion

unknown_anony's avatar
unknown_anony
Helper II
1 year ago
Solved

Trend chart display bug

Hi,  I am preparing a trend chart, in the data set i have value for only 2023 Dec, and Jan-Aug 2024, but in the above chart i am getting Dec in X axis for the year 2024 I have prepared a d...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    Create Calendar Table

    Calendar =
    VAR MinFactDate = MIN('FactsTable'[DateColumn])
    VAR MaxFactDate = MAX('FactsTable'[DateColumn])
    RETURN
    CALENDAR(MinFactDate, MaxFactDate)

    Create a measure that calculates data points only for dates that exist in your fact table:

    Filtered Values = 
    CALCULATE(
    SUM('FactsTable'[Value]), 
    NOT(ISBLANK('FactsTable'[Value]))
    )


    If this helped, a Kudos 👍 or Solution mark would be great!
    Cheers,
    Kedar Pande
    www.linkedin.com/in/kedar-pande

Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

Create Calendar Table

Calendar =
VAR MinFactDate = MIN('FactsTable'[DateColumn])
VAR MaxFactDate = MAX('FactsTable'[DateColumn])
RETURN
CALENDAR(MinFactDate, MaxFactDate)

Create a measure that calculates data points only for dates that exist in your fact table:

Filtered Values = 
CALCULATE(
SUM('FactsTable'[Value]), 
NOT(ISBLANK('FactsTable'[Value]))
)


If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande