is it possible to restrict the max value of x-axis according to another measure of other table

[hemingt]

I have two tables.

I create a measure Max_Week according to one table.

and created a Chart according to the other table.

I want to restrict the x-axis max value according to the measure Max_week. Is it possible?

Thank you!

[hemingt]

Is there any suggestion? Thank you!

[hemingt]

Here is my demo pbix file. <https://1drv.ms/u/s!AsM9bO8zGUN6qzfNZxmmRlNzWq-O?e=DhTMyQ>

[amitchandak]

You Graph is already responding to the slicer. Do you want to stop that?

[hemingt]

The x-axis max value is always 1917.

I want the Chart show as below.

if FixVersion selected as FMR2001, the max x-axis Week value should be 1917.

if FixVersion selected as FMR2002, the max x-axis value Week should be 1915.

if FixVersion not selected or all selected, the x-axis value should be 1917.

[amitchandak]

After I created a summarized table. I am able to restrict it below the value. Now it is not cumulative total. that need to be worked out

Table = SUMMARIZE(FILTER(Tasks,Tasks[Type]="END"),Tasks[FixVersion],"Max week",max(Tasks[Week]))

Count New = CALCULATE(COUNTROWS(Tasks), filter(Tasks,Tasks[Week]<=maxx(RELATEDTABLE('Table'),'Table'[Max week])))

Table is joined on the "fixed version" with Task Table.

[hemingt]

yes, but I want to the cumulative data. I have a try, and still could not get the cumulative data.

[v-shex-msft]

Hi @hemingt ,

You can try to use following measure formula if it suitable for your requirement:

Acumulative Count =
VAR __week =
    MAX ( 'Weeks'[Week] )
RETURN
    CALCULATE (
        COUNTROWS ( 'Tasks' ),
        FILTER ( ALLSELECTED ( Tasks ), [Week] <= __week ),
        VALUES ( Tasks[Type] )
    )

Regards,

Xiaoxin Sheng