Back in the good old days, when I had more time and ambition, I really wanted to make a “generic oData feed”… built into Excel. The idea was that since Power Pivot could read oData… if I could make it super easy to convert any data source into an OData feed, then we could easily consume almost any data source. For some reason I was always excited to feed the results of a PowerShell script into PowerPivot… probably because PowerShell is basically my favorite thing evar. Well, with the Continue Reading
Choropleth Maps in Power BI… with R
Rumors of my death were greatly exaggerated. Let’s get back to work. Fancy Map Okay, we want a map of “The States” where each state is colored by some metric. In our case, it is the Gross Margin we made off sales for that state. The style of map is called a Choropleth (apparently – I had no idea ). This is pretty easy in Power BI! Insert a “Filled Map” visual Click on your “state” column. Click on your GM$ measure. There is no step 4. Unless you want to tweak the colors a bit. I Continue Reading