SELECTEDVALUE question

[lhall37122]

Not sure why this is giving me fits but have stared at it long enough and need input. Simply trying to build a measure that determines if the endDate of a record is after the value selected in the Start of Month slicer. The slicer is based on a disconnected date table and just to test was trying to return the value of the slicer in my visual. But its not finding a value so returning the default date of today. What am I missing ??? 

[Anonymous]

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.

[lhall37122]

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. 

[Anonymous · Accepted solution]

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.

[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.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...