Forum Discussion
Filtering Chart by two values
Hello Folks.
I'm trying to filter a chart by two values.
Rules: If actual velocity projection is greater than total stories then i won't show others sprints
Can anyone help me? Is that possible?
TY guys
I think you will have to do this by creating 2 new measures for your chart. For the Total Stories measure the "trick" is to return the value of the base [Total Stories] measure if we are looking at only one sprint and the value of Total Stories is greater than the actual velocity projection
Total Stories for Chart = IF( HASONEVALUE( 'Sprint Table'[Sprint Name] ) , IF( [Total Stories] > [Actual Velocity Projection], [Total Stories] , BLANK() ) , [Total Stories])
For the velocity you'd follow a similar pattern, just check if the velocity is less than the total stories, otherwise return blank.
Actual Velocity Projection for Chart = IF( HASONEVALUE( 'Sprint Table'[Sprint Name] ) , IF( [Actual Velocity Projection] < [Total Stories], [Actual Velocity Projection] , BLANK() ) , [Actual Velocity Projection])
1 Reply
I think you will have to do this by creating 2 new measures for your chart. For the Total Stories measure the "trick" is to return the value of the base [Total Stories] measure if we are looking at only one sprint and the value of Total Stories is greater than the actual velocity projection
Total Stories for Chart = IF( HASONEVALUE( 'Sprint Table'[Sprint Name] ) , IF( [Total Stories] > [Actual Velocity Projection], [Total Stories] , BLANK() ) , [Total Stories])
For the velocity you'd follow a similar pattern, just check if the velocity is less than the total stories, otherwise return blank.
Actual Velocity Projection for Chart = IF( HASONEVALUE( 'Sprint Table'[Sprint Name] ) , IF( [Actual Velocity Projection] < [Total Stories], [Actual Velocity Projection] , BLANK() ) , [Actual Velocity Projection])