Forum Discussion
SELECTEDVALUE question
Hi lhall37122 ,
Based on the description, the error is that the measure DAX formula is not detecting the date selected by the slicer.
So, check that drag the start of month column to the slicer visual and check if a filter is applied.
Besides, creating a new blank report and copy the table data to the new report. Then, drag the start of month to the slicer visual in the new report.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi lhall37122 ,
Based on the description, try to check the start of month column in the slicer visual and verify the start of month column date type.
The DAX formula should display the slicer's date correctly.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply I can confirm that my "Start Of Month" is set as a DATE data type and looking at your sample .pbix file I can find any difference in my test measure vs yous so completely at a loss why the slicer value will not show correctly.
Hi lhall37122 ,
Based on the description, the error is that the measure DAX formula is not detecting the date selected by the slicer.
So, check that drag the start of month column to the slicer visual and check if a filter is applied.
Besides, creating a new blank report and copy the table data to the new report. Then, drag the start of month to the slicer visual in the new report.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
