I have had problems with Power Map not working for some time. I don’t remember when the problem first occurred but it was some time after I installed a batch of updates/patches for Excel.
My problem is this (well actually it “was” this) . There are 5 visualisations that come with Power Map, but only 1 was working for me – number 4 – the “heat map” as shown below.
Whenever I clicked on any of the other visualisations, they simply didn’t work. I got nothing. Nix! I tried to fix it for a while but then had to move on without solving the problem. My opportunity to use Power Map for a real business problem passed me by and I forgot about it.
Today I read Avi’s Post on PowerPivotPro.com and saw all of my missing visualisation in all their glory – I got jealous. So I decided to look into my problem a little deeper, and now I have found the solution.
The problem is that I am using a MacBook Pro as my computer and running Windows installed on Bootcamp virtualised through Parallels. Yes that is a lot of overhead I know, but it is the only way I am able to use my 27” iMac screen I have at home with my Laptop. So the issue is that Power Map requires DirectX and DirectX doesn’t work properly on many virtual machines. I have a MacBook Pro (Late 2013) i5 2.6GHz with 16GB Ram running the latest version of Parallels. Even though Parallels says it supports DirectX 10, I can’t get it to work. Now I know what the problem is, I can easily solve it by just running Windows in Native Bootcamp mode – Power Map works fine this way on my machine.
The biggest problem I had to find this solution to Power Map not working is that I thought it was the Excel Patch that caused the problem. Hopefully this information will help someone, or prevent someone having a problem.