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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
hooleee
Regular Visitor

Why is the value not displayed

It`s my chart。

hooleee_0-1703147320690.png

It`s my measure

hooleee_1-1703147403211.png

hooleee_2-1703147458531.png

why is the "lastValue" not displayed,but the total is right?

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

this is because the date table is like a hierarchy

Screenshot_4.png
you need to disable it like this

Screenshot_2.pngScreenshot_3.png

View solution in original post

5 REPLIES 5
Ahmedx
Super User
Super User

this is because the date table is like a hierarchy

Screenshot_4.png
you need to disable it like this

Screenshot_2.pngScreenshot_3.png

thanks for your detailed answer!

VijayP
Super User
Super User

@hooleee try DateAdd(Shees[Date].[Date]) ( additionla date tag) since you are not using Separate Date Table.

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


@viratkohli You have posted some Spam , try avoid posting irrelvant topics!

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


ryan_mayu
Super User
Super User

@hooleee 

I used the similar data to create the visual, should display the data .pls compare yours with mine. 

 

11.PNG

 

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors