Ignore Date Slicer for completed Projected displaying the visual

[SyedSami]

Hi,

I am displaying "Total cost" against Project and having one Slicer for Weekly "CutOff date". 

While selecting CutOff Date from Slicer, those projects which already completed in prvious week with their corresponding CutOff date are not displaying on the Visual which is logically correct behaviour of Slicer and visual. 

But in my requirement, I have to ignore Slicer selection for the specific completed Project and want to keep dispalying those project and its Cost on the visual. 

For you understanding kindly have a look at attached sample sanshot. 

Thanks in advance,. 

[SyedSami]

Hi Ashish,
For the time being I solved the my probleme by addinng below additinoal colum, but it will not work dynamically...in case if another project suppose project "C" completed then I will have to mention this project in DAX  as well...

So can you advise that how can i make it dynamic?

Ignore Completed Cutoff Date = if (AND (data[Weekly CutOff Date] = Value ("27-Jan-23"), data[Project]= "B"),MAXX(data, data[Weekly CutOff Date] ),data[Weekly CutOff Date] )

[SyedSami]

Hi Ashish,

I was not able to share the pbix file and its downloadble link. Below is my sample data that i used in PBI as mentioned in previous screnshot.  

Can you please load the same data and try with it, if it works for you. 

Project	Weekly CutOff Date	Total Cost (M $)	Status
A	3-Feb-23	2000000	In Progress
A	27-Jan-23	3000000	In Progress
A	20-Jan-23	1500000	In Progress
A	13-Jan-23	4000000	In Progress
A	6-Jan-23	5000000	In Progress
B	27-Jan-23	1500000	Completed
B	20-Jan-23	4000000	In Progress
B	13-Jan-23	5000000	In Progress
C	6-Jan-23	3000000	In Progress
C	3-Feb-23	3000000	In Progress
C	27-Jan-23	1500000	In Progress
C	20-Jan-23	4000000	In Progress
C	13-Jan-23	5000000	In Progress
D	6-Jan-23	3000000	Completed

[Ashish_Mathur]

Hi,

Someone else will help you with this.

[Ashish_Mathur]

Hi,

I am not sure how much i can help but i would like to try.  Share the download link of the PBI file.