VSCode extension for Power BI Custom Visuals


Visual Studio Code Extension This Visual Studio Code extension adds the option to directly start and restart the PowerBI Visual tools (pbiviz) for developing Power BI Custom Visuals. Features Add 'build-in' support for pbiviz in Visual Studio Code. Ctrl+F8: Start pbiviz and load the Power BI Custom Visual Crtl+Shift+F8: Restart pbiviz and reload the new Power BI Custom Visual code Ctrl+F9: Stop pbiviz History 0.0.3 (August 6, 2016) [Bug] Fixed restart sequence to avoid 'race' conditions with child process. 0.0.2 (August 6, 2016) Initial release Links Visual Studio marketplace GitHub repository…

Continue Reading

Power BI Hierarchy slicer


Hierarchy slicer The hierarchy slicer for Power BI provides the opportunity to simple select multiple members of different levels of a hierarchy as selection. The slicer can be used with an existing hierarchy or a manual created hierarchy. Example See here for an example if the embedded version is not working. Changelog See for the list of changes here. Future The following things are on the to-do list for a future release. The list is in a random order and sure not complete. [0.7.4] Expand / collapse levels [0.7.4] Style font size / color and background of items and header [0.7.4] Support for auto-created Power BI hierarchies, like date fields [0.7.4] Support for multi-select…

Continue Reading

Changelog Hierarchy Slicer


Hierarchy Slicer changelog Of the hierarchy slicer Power BI custom visualization the following versions are released with the following new features, changes and bug fixes. NOTE: All Power BI gallery visuals are distributed via the Azure CDN network and this will cause a delay of max a couple of days in delivering a new version. 0.8.x - (in development) Show/hide header More formatting option Show/hide '(blank) levels ('Ragged' hierarchies) Auto-create hierarchy out of DAX PATH fields 0.7.9 - (24 August 2016) Adding search support Configurable selected item font color [Bug] Expand/collapse fixed in IE11 [Bug] Filter selection saves with report 0.7.4 - (19 July 2016) Expand and collapse hierarchy levels…

Continue Reading

Managing Azure credits with Power BI


Recently I ran out of Azure credits before the new billing month was started. The result: Azure automatically disables the account and none of my resources were available. Next question was: how can I use Power BI to keep track of my credits? Can I Power BI help me in managing my Azure credits? Azure Management API With powerbi.com there is a content pack related to Azure, but it creates an operational dashboard and there are no spending reported. So I had to create it myself. Luckily a lot of Azure resources/services are available via different REST APIs. The Azure Resource Manager REST API was my first try. Is provides access to resources available within a subscription. But…

Continue Reading

Power BI Box and whisker chart


Power BI Box and Whisker chart A box and whisker chart shows basic statistical information (five-number summary) of a dataset: the 1st and 3rd quartile (box),the median (line), the mean (dot) and dependent of the type either the minimum and maximum value or the 1.5x interquartile range [IQR] (whiskers). Example See here for an example if the embedded version is not working. Chart types The box and whisker chart has three chart types to summarize a dataset. For all types, the box is showing the data between the 1st and 3rd quartile. Only the whiskers are different based on the chart type. Min/Max The whiskers in a min/max version are as long so they include all…

Continue Reading