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

[MartinaRa]

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

[lbendlin · Accepted solution]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...