Forum Discussion
Drill down on a filled map
So I have sales for a car company by state, and also some government data that has to do with registered cars in each state. Is it possible to drill down in a filled map to where I could see the amount of cars sold by the company by state and drill down to where I would see a map of the amount of cars registered by state as well in the same map, but just drilling down so you can see the difference in the color saturation more easily than you could with 2 separate maps? Also while I'm here is it possible to plot a normal map with the circle sizes with a filled map? The second question I basically assumed you couldn't do, but thought I would ask anyways. If you guys wanna see some pictures of the two separate graphs I have already made just let me know and I'll post them, but I don't see how that would help at the moment. If these are possible I'd like an explanation how to do this, because I've been playing around with it for awhile now, but haven't been able to figure this out. Thanks!
cole_lehmkuhler wrote:
I can send you some screenshots in a little, but I'm not trying to drill down from state. I'm trying to drill down by the color saturation field. I want to drill down from the sales by state to the vehicles registered by state, I just don't know if this is possible.
Hi cole_lehmkuhler,
It is impossible to drill down from the sales by state to the vehicles registered by state. Drill requires a visualization with a hierarchy, for more details, please check the following article. However, based on your description, no hierarchy exists in the above fields.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-drill-down-in-a-visualization/
Thanks,Lydia Zhang
4 Replies
Look at my response here on 05-04-2016 at this link
http://community.powerbi.com/t5/Desktop/Combining-filled-and-bubble-map/m-p/33777#M12032
If the data is on the state level - what are you going to drill down on the map to?
Post some sample data - and what you expect the result to be...
I can send you some screenshots in a little, but I'm not trying to drill down from state. I'm trying to drill down by the color saturation field. I want to drill down from the sales by state to the vehicles registered by state, I just don't know if this is possible.
cole_lehmkuhler wrote:
I can send you some screenshots in a little, but I'm not trying to drill down from state. I'm trying to drill down by the color saturation field. I want to drill down from the sales by state to the vehicles registered by state, I just don't know if this is possible.
Hi cole_lehmkuhler,
It is impossible to drill down from the sales by state to the vehicles registered by state. Drill requires a visualization with a hierarchy, for more details, please check the following article. However, based on your description, no hierarchy exists in the above fields.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-drill-down-in-a-visualization/
Thanks,Lydia Zhang
