Calculate line graph starting at 100%

[Anonymous]

Hi!

I am trying to create a graph like the one below in PowerBI (same idea, way different data). The idea is that whatever I pick as first date, it will use that value as 100% and recalculate the other measures accordingly.

To do it I am trying to obtain the Minimum date in the range, calculate the base value and then do the division. Nonetheless, 

as output I am obtaining only 1's (a flat line in the chart). It is giving me the same BaseValue as CurrentValue.

(I was following this link advise: https://stackoverflow.com/questions/70438070/powerbi-line-chart-growth-from-100)

Thanks in advance!

Here is my code:

Display_value =

Var MinYear = CALCULATE(

    MIN('Revenues with Main artist'[Date]),

    ALLSELECTED('Revenues with Main artist'[Date])

    )

Var BaseValue =  CALCULATE(

    SUM('Revenues with Main artist'[Monthly Total Gross Sales]),

    REMOVEFILTERS('Revenues with Main artist'[Monthly Total Gross Sales]),

    'Revenues with Main artist'[Date] = MinYear

)

Var CurrentValue =  CALCULATE(

    SUM('Revenues with Main artist'[Monthly Total Gross Sales]),

    ALLSELECTED('Revenues with Main artist'[Monthly Total Gross Sales])

    )

Var Division = DIVIDE(CurrentValue,BaseValue)

Return(Division)

[pi_eye · Accepted solution]

Hi

I was able to create such a chart:

Using this as measure:

single adjusted value =
var vminDate = CALCULATE (
    MIN (CPI[Date] ),
    ALLSELECTED ( CPI[Date] )
    )

var vbase = CALCULATE(
    sum(CPI[Sales]),
    FILTER(ALLSELECTED(CPI[Date]),
            CPI[Date]=vminDate))

return (sum(CPI[Sales])/vbase)*100

Try the above, or if you want to edit your code directly, replace the removefilters in the base value with a filter for all selected.

one more thing to try:
I noticed that if I have the date as a hierarchy in the chart, it has trouble calculating the min of the date, and returns flat lines

Chart with date as hierarchy:

However, when I change to the date as a value on it's own ,the problem is solved:

Chart with date as single value:

 HTH, 

Pi

[Anonymous]

Thank you! I have tried all solutions (exhausting them all) and the real issue was the date as a value instead of as a hierarchy,

Thanks again! 

[pi_eye]

It's often something that simple!

Glad it helped!