How to limit date axis from today to last value of data

[Anonymous]

Hello,

I'm having a problem displaying my data.

What I want is to show the X axis from today to the date with last value from another table. What I have is an overflow of dates as this (red line indicating where I want X axis to stop).

Additionally, my data model looks like this

[Date]1---*[valuetable]

And my measure like this:

CALCULATE(SUM('valuetable'[Values]),'valuetable'[Date]>=TODAY(),USERELATIONSHIP('valuetable'[Date],'Date'[Date]))

My date table covers a period from 1.1.2000 to 1.1.2040

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

Change Categorical to Continuous:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-eqin-msft · Accepted solution]

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-eqin-msft]

Hi @Anonymous ,

Please create a flag measure:

Measure = 
var _maxdate=MAXX(ALL('Date'),[Date])
return 
IF(MAX('valuetable'[Date])>=TODAY()&& MAX('valuetable'[Date])<=_maxdate,1,0)

And drag it to filter pane, set as "is 1":

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi!

This almost worked for me. Is there an easy alternation here so I can display blank dates as well? This measure does cut the date to last date of valuetable but it also erases empty values from X axis. 

[freginier]

Measure = 
SUMX( 
    SUMMARIZE(
        FILTER(
            'Table', 
            'Table'[Date]<TODAY()
        ),
        'Table'[Date],
        "@sum",SUM('Table'[Amount])
    ),
[@sum]
)