Forum Discussion

MartinaRa's avatar
MartinaRa
Frequent Visitor
3 years ago
Solved

If value is 'Unapproved', keep the same if it different, keep different

Hi 

I need to show for all 'Unapproved' status projects in the past periods, if and when they changed their status to any other than 'Unapproved'. I am able to select all Unapproved via slicer, but it excludes when a particular project changed its status to any other than 'Unapproved'. Could you help me with a measure to show only the 'Unapproved' for all periods, but when a project changes its status from Unapproved, the other status would populate showing the period when it changed and to which status? Some projects may remain for a few periods as Unapproved until they change to 'Approved' or 'Closed' or 'Rejected'. I was also trying to create some sort of a dashboard using columnar visual, if you could suggest any better to show trend each month how many  and in which period are still Unapproved and how many changed their status since and which period? This is to monitor 'Unapproved' projects changes and trend in approving.

Current slicer for Unapproved and table and visual.

Many thanks for any help

MartinaRa

 

1 Reply