Forum Discussion

icassiem's avatar
icassiem
Post Prodigy
7 months ago
Solved

Line chart data label on min, max, current points only for dynamic hierarchy (sample solution)

Hi,   i posted previously to show data lables on specific points but dynamic for qtr, year, month visual selection here is my prev post, and i received help by trying to create the additional meas...
  • icassiem's avatar
    icassiem
    6 months ago

    v-prasare  Thank You

    i have been playing around with chatgpt to help me , the below works on gettinfg the last month total only but not when i roll up to qtr where i want the ucrrent or last qter total to display

    This works for last only that has start of month date
    LastDateValueLabel =  
      VAR MaxFactDate =
        CALCULATE(
            MAX(FACT[Date]),
            ALLSELECTED('Calc_Calendar')
        )
    RETURN
    IF(
        MAX('Calc_Calendar'[Date]) = MaxFactDate,
           FACT[ActualBaseMeasAgg],
        BLANK()
    )


    Now trying date hierarchy:

    VAR CurrentMaxDate =
        CALCULATE(
            MAX(FACT[Date]),
            ALLSELECTED('Calc_Calendar')
        )

    VAR CurrentPeriod =
        SWITCH(
            TRUE(),
            ISINSCOPE('Calc_Calendar'[DateStartOfMonthDescr]), "Month",
            ISINSCOPE('Calc_Calendar'[DateFinQuarterDescr]), "Quarter",
            ISINSCOPE('Calc_Calendar'[DateFinYearDescr]), "Year",
            "Other"
        )

    RETURN
    SWITCH(
        CurrentPeriod,
        "Month",
            CALCULATE(
                FACT[ActualBaseMeasAgg],
                FILTER(
                    ALL('Calc_Calendar'),
                    'Calc_Calendar'[Date] = CurrentMaxDate
                )
            ),
        "Quarter",
            CALCULATE(
                FACT[ActualBaseMeasAgg],
                DATESQTD('Calc_Calendar'[Date])
            ),
        "Year",
            CALCULATE(
                FACT[ActualBaseMeasAgg],
                DATESYTD('Calc_Calendar'[Date])
            ),
        BLANK()
    )