Forum Discussion
Actual vs Target Modeling Issue
Hello, I'm trying to build a visual which shows me my Actual vs Target. I need this broken down for all of our store locations. I created the Data Model, but for some reason, the visual shows the...
Hi Wilson,
When I switch my Small Multiples to my Location from my DimLocation table, it breaks the visual it says "Couldn't load data for this visual"
Tooks,
I get errors to your pbix because I don't have permissions to some of your tables. However, your issue in using the Location from the dimension table likely stems from the fact that this is a mxed storage mode model, with DirectQuery tables, Imported tables and a calculated table pointing at one of your DirectQuery tables.
This maaaaaay be a decent place to start digging. Unfortunately, I don't work with them enough to help you here.