Clustered column chart not showing both measures

[michaelu1]

Hi,

I am trying to add 2 measures to my chart showing ytd this year and ytd last year.

For some reason only the measure that is actually on top in the y-axis bucket will show up on the actual chart.

When I go to view as table you can see that the data is there correctly but its not showing up on the actual chart.

[JadhavVarsha_13]

Hello @michaelu1  seems like your number format is different for both the fields this year is in currency format and ytd last year in numeric, you would need to chenge the format.

Hope this helps

[michaelu1]

It doesn't seem like that worked unfortunately..

[JadhavVarsha_13]

Oh that should work actually, is it possible for you to post the file here 

[michaelu1]

I afraid I can't 😞

But I can post the relevent measures that I used:

YTD Balance ACT = CALCULATE(SUM('Financials'[Pos Balance]),Financials[Type]="Actual",DATESYTD('Date Table'[Date]))

Total Selected YTD/Unit =

    DIVIDE([YTD Balance ACT],[C Rentable Units])

Total Selected YTD/Unit last year =

        DIVIDE(

            CALCULATE([YTD Balance ACT],DATEADD('Date Table'[Date],-1,YEAR)),

            [C Rentable Units])