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
hemingt
Helper V
Helper V

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

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!

 

7 REPLIES 7
hemingt
Helper V
Helper V

Is there any suggestion? Thank you!

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

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.

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.

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

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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.