Urgent- Filter shows all the dates in the min and max

[Anonymous]

Hi Everyone,

   I created one calender table by using start date and end date in that table I created columns for fiscal years.

  Then  I created a two measures for  min of start date and max of end date in my original table.

  The measures are

FMinimum date = CALCULATE(MIN('Test'[startdate]),ALLSELECTED('Test'[startdate]))

FMaximum date = CALCULATE(MAX('Test'[enddate]),ALLSELECTED('Test'[enddate]))

  But my issue is I used the slicer of fiscal column it shows the start dates and end date for all the year but the data is shown correct for related Fiscal years what i filter. I dont want to display all the dates. I want to show all the start date and end date belong to fiscal years only. Kindly help me on this issue.

Advance thanks to all 

[Anonymous]

Hi @Anonymous ，

Are you using date hierarchy in the slicer?If so,remove the hierarchy,just use the date instead.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

hi @Anonymous 

  thanks for your reply. I am not using the hirearchy filter I created one more column for fiscal years that column only I used for filter becasue i want to show fiscal years of data only...

I used this measure to create fiscal years is

Financial Year =

VAR fy =

IF (

MONTH ( 'Calendar date'[Date] ) <= 3,

VALUE ( FORMAT ( 'Calendar date'[Date], "YY" ) ) - 1,

VALUE ( FORMAT ( 'Calendar date'[Date], "YY" ) )

)

RETURN

CONCATENATE ( "FY", CONCATENATE ( fy, CONCATENATE ( "/", fy + 1 ) ) )

Advance thanks

[Anonymous]

Hi @Anonymous ,

Sorry I cant reproduce your senario,could you pls show me your sample data ?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi @Anonymous ,

      I attach my sample pbix file for your reference. I created financial year column for 1 april to 31 march . I used this filter to show the maximum and minimum dates of records It shows the all the records with null values. I attach my screenshot for your reference.

Kindly check this pbix file for your reference. Help me as soon as possible..

https://1drv.ms/u/s!Aoy7ZnpipsSQa_GXKAEM3xBCBRo?e=cQ518k

Thank you