Forum Discussion
Changing date relationship makes visuals blank
I am currently working with a direct query to dataverse so I made my own date table for the report. However, I had to change the relationship from the "Created On" date to "Date Fulfilled". When I modified the relationship it resulted in a lot of my viuals/graphs turning blank and when I go to table view there isn't anything populated. I did some research but I can't seem to pinpoint the exact issue so if anyone has any ideas, that would be amazing. Thanks!
I figured it out, I had to make the storage mode Dual so now everything loads. Thanks for your help.
2 Replies
PaulDBrownCommunity Champion
Instead of changing the relationship, why not create a new inactive one to Date Fulfilled, and create measures using USERELATIONSHIP?I figured it out, I had to make the storage mode Dual so now everything loads. Thanks for your help.