Forum Discussion

enricofumagalli's avatar
enricofumagalli
Frequent Visitor
2 years ago
Solved

graphic line report

Deal all,

 

I have a report represented via graphic line in which there are three metrics on the time axis.
These are three cumulative metrics for which the graphs are lines that start from zero and grow as the months pass.
One of the 3 metrics represents an actual value and the others are forecast values.
The actual metric obviously makes sense until the current month, after which its trend clearly flattens out (as there is no new data to add in the months to come).

My question is: for an aesthetic reason, is it possible to "stop" the graph of the actual measurement at the current month? (paraphrasing Excel, as if I took for this metric a date range that stops at the current month so the graph line would stop at the current month)

Thanks in adavance

Enrico

Need Help
  • MNedix's avatar
    MNedix
    2 years ago

    Is that metric comprised as values from a column? There could be multiple scenarios here.

    1. Lets's say there is a column called "Actual Sales"

    You could try something along the line of:

    Flag = IF(ISBLANK([Actual Sales]),0,1)

    Then you add this Flag to the Filter section and you should probably do "Show items when the value - is - 1"

     

    2. If you have a column called "Sales" where you have values like - Actual, Forecast etc., you could do:

    Flag = IF(MAX([Date])>TODAY())&&MAX[Sales]="Actual",0,1)

    And then do the same thing with the flag.

     

    If this solves your problem then please mark it as the solution.

2 Replies

  • MNedix's avatar
    MNedix
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Is that metric comprised as values from a column? There could be multiple scenarios here.

    1. Lets's say there is a column called "Actual Sales"

    You could try something along the line of:

    Flag = IF(ISBLANK([Actual Sales]),0,1)

    Then you add this Flag to the Filter section and you should probably do "Show items when the value - is - 1"

     

    2. If you have a column called "Sales" where you have values like - Actual, Forecast etc., you could do:

    Flag = IF(MAX([Date])>TODAY())&&MAX[Sales]="Actual",0,1)

    And then do the same thing with the flag.

     

    If this solves your problem then please mark it as the solution.

  • _AAndrade's avatar
    _AAndrade
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    Hi,

    For your forecast measuse you can use a IF statement like this:

    DAX measures that I'm using in my example:

    Sales Actuals = SUM(T_SalesComp[Actual])

Sales Forecast = 
IF(
    NOT(ISBLANK(T_SalesComp[Sales Actuals])),
    SUM(T_SalesComp[Forecast])
    )

    My data table:

    My model:


    I hope this can help you.