Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Is there any suggestion? Thank you!
Here is my demo pbix file. <https://1drv.ms/u/s!AsM9bO8zGUN6qzfNZxmmRlNzWq-O?e=DhTMyQ>
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |