measure filer issue

[Hussein_charif]

hi,

i have this table :
date period =
UNION(
ADDCOLUMNS(
DATESMTD(DateTable[Date]),
"type","MTD"
,"order",1
),
ADDCOLUMNS(
DATESQTD(DateTable[Date]),
"type","QTD"
,"order",2
),
ADDCOLUMNS(
DATESYTD(DateTable[Date]),
"type","YTD"
,"order",3
),
ADDCOLUMNS(
PREVIOUSYEAR(DATESYTD( DateTable[Date])),
"type","Last Year"
,"order",4
),
ADDCOLUMNS(
PREVIOUSQUARTER(DATESQTD( DateTable[Date])),
"type","Last Qtr"
,"order",5
),
ADDCOLUMNS(
PREVIOUSMONTH(DATESMTD( DateTable[Date])),
"type","Last Month"
,"order",6
), ADDCOLUMNS(
CALENDAR(MIN('DateTable'[Date]),MAX('DateTable'[Date])),
"type","All Time"
,"order",7
),
ADDCOLUMNS(
CALENDAR(MIN('DateTable'[Date]),MAX('DateTable'[Date])),
"type","Custom"
,"order",8
)
)
i am using the type slicer, and a date slicer (between). in my date slicer i have this measure in the filter pane set equal to 1 :
Date Slicer Filter =
IF(
SELECTEDVALUE('date period'[type])= "Custom",
1,
0
)
but even when i choose Custom in my type slicer, i am unable to edit using that date slicer. although, if i use the measure in a card it returns 0 and 1 properly when selecting the type, and i also have the same measure but for a title, if i use that also alone it works. it just doesnt work on the date slicer, also, it is working on 1 page, but the other 2 pages it isn't. both pages have no other filters applied that might cancel it. and even if i create a new page and copy the working slicers, they dont work in the new page

this is the video reference i was working with:
https://www.youtube.com/watch?v=fKygF7VEJnQ&t=316s 

[v-venuppu]

Hi @Hussein_charif ,

I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.

Thank you.

[v-venuppu]

Hi @Hussein_charif ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-venuppu]

Hi @Hussein_charif ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @tharunkumarRTK @lbendlin for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[v-venuppu · Accepted solution]

Hi @Hussein_charif ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @tharunkumarRTK @lbendlin for the prompt response.

Your measure is correct, but the date slicer only works if interactions and filters are set properly.

1.On non-working pages, use "Edit Interactions" to ensure the type slicer affects the date slicer.

2.In the date slicer's Filter pane, apply [Date Slicer Filter] = 1.

3.Avoid relying on copy-pasting slicers across pages - recheck interactions each time.

4.Check for hidden filters that might override the measure logic.

5.If still broken, test in a clean PBIX to isolate the issue.

If the issue still persists, kindly share the sample data as suggested by others , so that it will be helpful for us to look into the issue.

Thank you.

[tharunkumarRTK]

@Hussein_charif 

Did you check the interaction between period slicer and Date Slicer?

Does the relationship exists between date table and the period table?

please share the file with sample data if possible so that someone can troubleshoot and can guide you further

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...