Forum Discussion

Alph4's avatar
Alph4
Frequent Visitor
3 years ago
Solved

HELP CONDITIONAL DATA LABEL

Good Morning ! Guys all right? I wanted to clear a doubt: Indicators with blue color is the baseline cumulative, Green color is the realized cumulative and orange is the projected cumulative. However, I wanted to create a condition that the accumulated projected line only shows data labels for the next months. Could you create a conditional formatting of the label's color or adjust the projected cumulative formula.? Another however is the filter for the Y axis, sometimes it ends up overlapping the data labels of the lines. How do you adjust it dynamically? The formulas are below:

 

_AccumulatedForecast =
CALCULATE(
     [Qty. Liabilities - Expected],
     FILTER(
         ALLSELECTED(dCalendar),dCalendar[BaseData]<=MAX(dCalendar[BaseData])
_AccumulatedProjected =
CALCULATE(
     [Qty.Projected Liabilities],
     FILTER(
         ALLSELECTED(dCalendar),dCalendar[BaseData]<=MAX(dCalendar[BaseData])
_AccumulatedRealized =
IF
     (MIN('dCalendar'[BaseData]) <= CALCULATE(today()),CALCULATE(
     [Qty.Liabilities Accomplished],
     FILTER(
         ALLSELECTED(dCalendar),dCalendar[BaseData]<=MAX(dCalendar[BaseData])

 


Gostaria de criar uma condição que 

 

DAX
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Alph4,

    What type of effects are you means? Hide specific range data line on chart or exclude the calculation of previous date ranges?

    If you mean the first one, you can add if statement to check the current date and prevent the formula calculate on not wanted ranges.

    For the second one, You can modify the formula to add the start date filter into the expression, and it will exclude the previous range calculation in your formula.

    Regards,

    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Alph4,

    What type of effects are you means? Hide specific range data line on chart or exclude the calculation of previous date ranges?

    If you mean the first one, you can add if statement to check the current date and prevent the formula calculate on not wanted ranges.

    For the second one, You can modify the formula to add the start date filter into the expression, and it will exclude the previous range calculation in your formula.

    Regards,

    Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Alph4,

    Any update on this? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

    If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng