7th August 2019 Power Automate – Creating Adaptive Cards This post is to support a video posted on YouTube regarding creating an adaptive card for Microsoft Teams using Microsoft Flow. Categories How to/Flow/Introduction
6th August 2019 SVG in Power BI Part 6 – New Icon Conditional Formatting In July 2019 Power BI Desktop update they included new conditional formatting on table and matrix to include icons. These icons can be defined using SVG which is pretty cool. So this is a new post in my Power BI SVG series looking how we can use SVG icons in conditional formatting. Categories Power BI/SVG/Updates
27th July 2019 Power BI – DAX CrossFilter Function In this post I am continuing my campaign against bi-directional relationships. This is an introduction of the CROSSFILTER function which can be used to simulate the bi-directional relationship in a calculation. Categories Power BI
26th July 2019 Power BI – Cascading Slicers In this post I will look at filtering one slicer based a selection in another slicer. June 2019 Power BI Update included an update to allow a slicer to be filtered based on a measure, which means that you no longer need to use bi-directional relationships. Categories Power BI/How to
25th July 2019 Power BI – Using Inactive Relationships in a Measure In this post I will show a simple example of how to use a different relationship between two tables in a measure. The example I will use is a list of tasks with start and finish dates. The request is for how many tasks start per week and how many finish per week to be plotted on a column chart. Categories Power BI/Intermediate
9th July 2019 Power BI – Data Refresh Date In this quick post I will walk through adding a data refresh date on a report page in Power BI. Categories Power BI/How to
8th July 2019 PowerApps – Using JSON Function to Save Pictures In this post I will be explaining how to use the JSON Function to simplify the saving of multiple pictures from a PowerApp to a SharePoint library using Flow. There have been many wonderful workarounds to do this, finally we now have a slightly less Heath-Robinson method. Categories PowerApps/How to/Power Automate
13th June 2019 Power BI – Conditional Formatting Update The June 2019 update for Power BI included a few updates for conditional formatting, for visual backgrounds, titles, cards and gauges. This post is my take on the updates and on how I prefer to do the logic behind choosing a colour. Full details of the June 2019 update can be found at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2019-feature-summary/ Applying Conditional Colour Formatting This update... Categories Power BI/Updates
8th June 2019 SVG in Power BI – Part 5 – Using SVG Rotate In this post I will introduce the possibilities that SVG rotate gives. This post will walk through creating a dial. Categories SVG/Power BI
7th June 2019 PowerApps – Transparency Update Post describing the update to ColorValue to include transparency and the addition of transparent colour. Categories PowerApps/Updates