Forum Discussion

iGWizard's avatar
iGWizard
Frequent Visitor
1 year ago
Solved

Displaying Data Labels at 3 month intervals

Hi, I have a line chart, and would like to display its data labels at 3 month intervals (to avoid over crowding). I understand I need to use DAX to fulfill this, potentially using DATESINPERIOD(). ...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    iGWizard 

    New Measure

    LabelEvery3Months = 
    IF(
    MOD(MONTH('Date'[Date]), 3) = 0, 
    [YourMeasure], 
    BLANK()
    )

    Replace [YourMeasure] with the measure or value you’re plotting on the line chart

    Use this new LabelEvery3Months measure as your data labels instead of the regular measure.

     

    💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
    Cheers,
    Kedar
    Connect on LinkedIn

Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
1 year ago

iGWizard 

New Measure

LabelEvery3Months = 
IF(
MOD(MONTH('Date'[Date]), 3) = 0, 
[YourMeasure], 
BLANK()
)

Replace [YourMeasure] with the measure or value you’re plotting on the line chart

Use this new LabelEvery3Months measure as your data labels instead of the regular measure.

 

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn