topic Re: Powerbivisual in Developer

Powerbivisual

Millar — Mon, 08 Jan 2024 12:44:41 GMT

Need to create a date filter by using slicer which contain start date and end date
when ever report gets loaded its should show default values form
start date should be :01-Feb-2023
end date should be: Today's day ( dynamically)

also when ever user want to change the same start data and end date those option also need to enable in slicer.

Re: Powerbivisual

Anonymous — Tue, 09 Jan 2024 06:21:31 GMT

Hi @Millar ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

Table 2 = DISTINCT('Table'[Date])

2. Create measure.

Flag = var _mindate= MINX(ALLSELECTED('Table 2'),'Table 2'[Date]) var _maxdate= MAXX(ALLSELECTED('Table 2'),'Table 2'[Date]) return IF( ISFILTERED('Table 2'[Date])=FALSE()&&MAX('Table'[Date]) >=DATE(2023,2,1)&&MAX('Table'[Date])<=TODAY(),1, IF( ISFILTERED('Table 2'[Date])=TRUE()&&MAX('Table'[Date]) >=_mindate&&MAX('Table'[Date])<=_maxdate,1,0))

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Slicer has no selected value

Slicer selected value

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Re: Powerbivisual

Millar — Thu, 11 Jan 2024 16:44:00 GMT

New column created under table level

Period = if('DMADP OPEM_ADP_DATE_D'[Date]>EOMONTH(TODAY(),-12)&&'DMADP OPEM_ADP_DATE_D'[Date]<=TODAY(),1,0)

And placed under page filter level set values as 1