Category Archives: Uncategorized

Power BI Infographic Designer

I was about to start badgering our custom dev team to create a plugin for Power BI, to enable in the card visualisation background images and some text formatting for a project I was on, but then a new custom visualisation for Power BI was released.

https://powerbi.microsoft.com/en-us/blog/quickly-create-infographics-with-the-infographic-designer-custom-visual-for-power-bi/

Looks great and I’ve been playing with it for the last few days and for some instances will work very well, but its not (in my opinion) production ready for some of the visualisations. Why? two main things are an issue.

1 – It doesn’t preserve the formatting of the measures. So anything i set a ‘,’ with two decimal places, or format it as a percentage, it will not show it. I get 0.3874634793290000000000. Well that’s a bit pants

2 – Fill percentage doesn’t work in a¬†intuitive way. For a range of values it takes the highest value and then fills the rest with a ratio to the highest value. For example

infographic-issue

I’ve set some values as 75, 55, 40, 33, and then added a bit of the internal art to show a fill percentage. I was expecting the 75 value to only show a fill of 75%, but it takes the highest value, fills it to 100%, than based on that ratio will fill the rest, so a value of 37.5 (half of 75) will fill the next image as 50%. I’ve tried setting the values as 75%, 0.75, 75, but nothing seems to work. I’ve emailed the team that make it with some suggestions.

1 – A tick box or other option that can indicate that the value is a percentage and should fill accordingly

2 – Be able to set the unfilled area via a measure, so you can a target, set a filled (80) and unfilled value (20) and it will work out the correct ratio to fill it.

There might be a work around, where you have two layers. I’ll experiment and update the article when I can! But it’s will be a valuable addition to the visuals if the team can tidy it up in a few places.

Importing data into Power BI from Azure Marketplace

There are a number of articles on the net about importing data into Power BI from the Azure Market place, but most don’t look at the difference in importing directly from the table or using the filtered URL to drive the report. One of my wonderful colleagues had an issue with getting data into Power BI to do a mash up between footfall data and weather for a client.

So using the example UK Met Office data set in Azure Data Marketplace, you can connect to the table exposed in the Met Office set. Continue reading

Pygame install headaches

Been a bit of a while since the last post, busy doing the day job.

I had a few issues installing Pygame, the Python plugin. I was using the PIP command to install the package but it wasn’t liking the path, the command or anything. After a bit of Googling, and a Bing search (I know, but it is getting better) nothing seemed to match. However I found a solution

Put the Pygame ‘whl’ file in the Pyhton folder, then run the PIP command. That worked! I’m not sure if this a windows config issue with Python or just my PC. Don’t forget run the CMD in as an administrator.

PIP Command