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?

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

    Hello,

    Actually I do have data up until december 2019.

    I wish I could share the model, but I'd have to get approval from far too many people.

     

    So yeah, I have work around developed, but I'm trying to understand why this won't work. As of right now this measure is breaking my basic understanding of how filter/slicers are applied.

    • v-lili6-msft's avatar
      v-lili6-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      hi rtaylor 

      Please see this screenshot, after i reset all the slicer and then select Fiscal Year 2019,Month Aug, Now there is no data in [Budget Summary Ovrhead] for choose. This means that there is no data.

       

      You said that you do have data up until december 2019, if you mix up the fiscal date and calendar date in the model? or please check that if it is indeed that there is data in fiscal date aug 2019 in your power bi report.

       

      If you still have problem, please share your sample pbix file for us have a test. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

       

      Regards,

      Lin