I have spent the last 2 weeks reverse engineering a #PowerBI #dashboard built by my Chinese colleagues. I re-wrote the #SQL , I went through the #PowerQuery transformations and it just wouldn't accept the data format and display the visuals. And then I pressed the only option in a custom slicer, which normally would be on by default but it's a custom one so no. And suddenly the lights came on and everything works. I am considering adopting a new nervous tick for cases like this. FML.