Forum Discussion

rtaylor's avatar
rtaylor
Icon for Helper III rankHelper III
6 years ago

SeletedValue function with Date Filter not displaying properly.

Hello and Thanks in Advance!   I created a measure using selectedvalue function to display a category as a title. The problem is whenever I select any month to filter by, that isn't the first month...
Need Help
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
6 years ago

It's hard to say without being able to see your data model. But it looks like you have some sort of bi-directional filtering going on and you only have data for Jul 2019, so if Jul 2019 is not selected the slicer has no values hence SELECTEDVALUE() returns it's alternate value. Changing the bi-directional filtering to single directional might fix this (although it could cause other issues depending on how you have modelled your data)

rtaylor's avatar
rtaylor
Icon for Helper III rankHelper III
6 years ago

Thank you for the reply. There is data in the Aug 2019. I can filter that data no problem. Its just with this particular measure nothing shows up.

 

Do you know if there is a filter/slicer heirarchy could be affecting the model?

 

Like if I sort by category, and then apply the date filter, I lose the category filter?