Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
michaelu1
Helper II
Helper II

Clustered column chart not showing both measures

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.

 

michaelu1_0-1679591900795.png

 

michaelu1_1-1679591956101.png

 

 

4 REPLIES 4
JadhavVarsha_13
Resolver II
Resolver II

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

It doesn't seem like that worked unfortunately..

 

michaelu1_0-1679593724288.png

 

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

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])
  

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.