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
suvechha
Helper IV
Helper IV

Year reflecting different ?

Hi there,

Can anyone explain why the year is different in the tables below image:

 

suvechha_0-1597818639978.png

Thanks,

Suvechha

1 ACCEPTED SOLUTION
harshnathani
Community Champion
Community Champion

Hi @suvechha ,

 

 

The value has aggregated.

 

Right click on the measure and click Don't Summarize.

 

1.jpg

 

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@suvechha , By default date, add as date hierarchy. You can right and use date (In visualization Tab.)

 

refer this

https://radacad.com/power-bi-date-dimension-default-or-custom-is-it-confusing

harshnathani
Community Champion
Community Champion

Hi @suvechha ,

 

Also a good option to Disable Auto Date Time

 

https://www.youtube.com/watch?v=d4yAzhIQqNk

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

harshnathani
Community Champion
Community Champion

Hi @suvechha ,

 

 

The value has aggregated.

 

Right click on the measure and click Don't Summarize.

 

1.jpg

 

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

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.