Visualisation (blank)

[Philwantling]

Hi,

i've appended some data to my source excel spreadsheet and hit the refresh button. Only problem is, now my visualisations dont work. I;ve checked the column types, and all data seems to be correct. Any ideas?

[vanessafvg]

@Philwantling and can you see data in your model?

[Philwantling]

Yeah, i can see the data perfectly fine. If i start a new doc and get the same data, it works fine in the new document.

[Philwantling]

@vanessafvg

[vanessafvg]

@Philwantling so you saying in a new power bi it works find with the same visual and the data but in the current it doesn't?

i dont suppose you can share your pbix?

[Philwantling]

Hi @vanessafvg

That's correct. 

yeah, sure thing. .pbix and original data enclosed here: Dropbox

The only differece to the native data and the model in PBi are the calculated columns for total load, DCiE and PUE.

[Philwantling]

@vanessafvg there's a video here showing the issue a bit more clearly: https://www.dropbox.com/s/b0sunpsyslqys2s/2017-07-17_14h27_45.mp4?dl=0

[vanessafvg]

@Philwantling the only difference i can see is that in the one you use a date filter and the other you dont, with your incremental load are you sure dates are populated correctly?

[vanessafvg]

@Philwantling ok scrap that i can see in the first screenshot the dates are there

[vanessafvg]

@Philwantling to be honest its going to be really hard to figure it out without actually having access to the pbix,

[vanessafvg · Accepted solution]

@Philwantling aha!

you going to laugh when i tell you what the issue is

your filter on site, it says all but its lying, only hong kong is checked, i clicked on east and boom the data arrived

[Philwantling]

@vanessafvg Balls. Where on earth is that? I'm not seeing a filter?

[Philwantling]

@vanessafvg got it. Again, balls...and also, thanks.

[vanessafvg]

[Philwantling]

@vanessafvg There's a copy enclosed in the first dropbox link.