Hat Full of Data - Page 9 of 12 - Laura GB's notes on how she made data behave

15th April 2020

Power Query – Replace Values for Whole Table

Today’s challenge was to replace the values on all the columns in the query when I know the columns will change so I don’t want to name them.

Power Query/M/Power BI

9th April 2020

Power Apps – Build a Responsive App – Adding Dynamic Containers

In this post we will use dynamic containers to arrange out content so it moves to the planned location at the different screen sizes. We will need to calculate the screen size and then use it to position and size the containers. This post assumes you’ve done everything in the first 2 posts. Calculate Screen Size In order to make...

PowerApps

8th April 2020

Power Apps – Build a Responsive App – Initial Setup

A responsive app resizes the app based on the browser window and moves parts of the app to make the app work in different screen sizes. The most common sizes to handle are monitor, tablet and mobile phone. Create the Responsive App In the video and for my example I design the app based on a the larger size and...

PowerApps

8th April 2020

Power Apps – Build a Responsive App – Planning

Before you start a responsive app you need to plan where each element will be on the screen at the different screen sizes. Planning is vital.

PowerApps

3rd April 2020

Power BI – COALESCE Function to Remove Blanks

This post walks through a simple use of the coalesce function to prevent a measure returning Blank. This function was introduced to Power BI in March 2020.

Power BI

25th March 2020

Power BI – Introducing the Hierarchy Slicer

The new hierarchy slicer allows for data to be sliced based on different levels. This will reduce the number of slicers required on a report page.

Power BI/How to

9th March 2020

Power BI – Reset Slicers with a Bookmark Button

When your report has a bunch of slicers and charts that can also add filters to the page resetting back to no filters can be painful. So we need a quick way to reset slicers. This post walks through the steps of creating a bookmark and the using that bookmark to reset the page by clicking a button. Introduction This...

Power BI/Introduction

6th March 2020

Power BI – Slicers Introduction

Power BI reports can be made more flexible using simple slicers to allow your report consumers to slice and dice the data shown.

Power BI

21st January 2020

Power BI – Connecting to Project Online

This post walks through connecting to Project Online to visualise the data in Power BI. This is the first post in a series of building a set of reports.

Power BI/Project

27th December 2019

Power Apps – 12 Days of Components

This post is to provide the code and resources to support my 12 Days of Components videos which use SVG to create a range of graphics.

Uncategorized/Components/PowerApps/SVG