Date slicer in power bi report not working as expected which is embedded in web app

[SwathiJanu]

date slicer which is of range type, doesn't show values as per the web app filters applied where this power bi report has been embedded

[v-kongfanf-msft · Accepted solution]

Hi @SwathiJanu ,

As @SaiTejaTalasila  said, please check the relationship between the data models.

after create relationship between tables:

Or you can create the following measure to achieve a similar effect.

MEASURE =
VAR min_ =
    MIN ( 'Date'[Date] )
VAR max_ =
    MAX ( 'Date'[Date] )
RETURN
    IF ( MAX ( 'Table'[Date] ) <= max_ && MAX ( 'Table'[Date] ) >= min_, 1, 0 )

Best Regards,
Adamk Kong

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

[SaiTejaTalasila]

Hi @SwathiJanu ,

Please check your datamodel relationships and check do you have inconsistent data.