I need to update the Column Values based on the date slicer values selected on the dashboard

[dataexplorer123]

Let's say I have a table have Parks information like

Park Names and Park IDs

Then I have another table which shows the inspection completed in those parks, having columns
Timestamp, Park IDs, Inspected by, Comments, etc.

Based on the timestamp I have created a date slicer on the Power BI dashboard


I have added new column Current Status in the first table that lists all the Park Names and other information. And I want to make this new column values dynamic "Completed" or "Not Completed" depending upon the time selected on the slicer.  So, if the Second table which lists the inspection details and it timestamp lies within the selected date range then the value in the first table column should become "Completed". If the slicer date range goes below or above the timestamp of inspection then this new column value changes to "Not Completed". Essentially, the value of this column needs to by dynamic and dependent upon the date range selected on the slicer.

The Final goal is to display the table with all the Park Names and Current Status of its inspection dependent upon the date range from the slicer.  Also if possible I want to show the Completed and Not Completed values as red or green icons or get its font color green or red.

[v-prasare]

Hi @dataexplorer123, Thanks for reaching out MS Fabric community support.

Can you please share your sample data or PBIX file here for above scenario to narrow down issue you are encountering. we will try to repro the scenario you mentioned and come up with best possible solution here.

Thanks,

Prashanth Are

[dataexplorer123]

https://drive.google.com/file/d/1Y1bd98X0FyMYIdMkeeYGvP5QE1F5nSB_/view?usp=sharing 

[v-prasare]

@dataexplorer123, 

I’m not able to access below drive link given. Can you please provide sample data file here.

[dataexplorer123]

Try this link now:

https://drive.google.com/file/d/1XjgNh8W31G3LNU-jPK_PUJ5UbwGv63Y6/view?usp=sharing

[v-prasare · Accepted solution]

Hi @dataexplorer123,

Hope your doing well.

Apologies for the delayed response. the measure looks fine, but it seems the date slicer might not be working as intended. Could you please remove the "Between" slicer and try again? by doing this i can see the data changing dynamically for selected date range.

completed:

not completed:

Thanks,

Prashanth Are

MS Fabric community support.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query.

[dataexplorer123]

I can find an option to attach something over here.

[shobhit1117]

You can create a measure to capture the selected date.

Selected Start Date = MIN('Table'[Date])

Selected End Date = MAX('Table'[Date])

Then you can create a column based on the condtion to show  "Completed" or "Not Completed" ,

you can use conditional format to show red and green.

[dataexplorer123]

I tried doing that, but still the Completed and Not Completed status doesn't get updated once I change the slicer dates on the dashboard. It gives the total count of inspection being done since the inception. That means it gets the minimum value from the Inspection table and Maximum value, and since all the inspections lie within that time frame so it gives back the count of all the inspected parks or mark all of the inspected parks as completed without considering the time slicer selection.