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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
kap_55
Frequent Visitor

Show YTD current value of mesure for future months

Hi,

I have problem with Bar Chart showing value for end date of year (as it should be) but I want it to show specific date value.

missingbar.PNG

Years prior show value for last day of the year but current value does not exist for now. I mean I excluded it with my DAX:

 

 

Final =
    IF (
        MAX ( 'Calendar'[Date] ) <= EDATE ( EOMONTH ( TODAY (); 0 ); -1 );
        [Measure];
        BLANK()
    )

 

 

This is suppose to insert blank if we are not greater or the last day of current month.

values.jpg

!In this picture there is 0 not blank, so the December row is visible!

So I have two options and I think one is not possible:

1) Make bar chart show November value for only 2019 (I think this is not possible)

2) Repeat November value in December without any influence of values already existing in December.

 

My measure Final is quite complicated and I cannot change it much.

Is this somehow possible?

Thanks.

K.

0 REPLIES 0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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.