July 2019 - Hat Full of Data

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.

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.

How to/Power BI

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.

Intermediate/Power BI

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.

How to/Power BI

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.

Flow/How to/PowerApps

Monthly Archive: July, 2019

Power BI – DAX CrossFilter Function

Power BI – Cascading Slicers

Power BI – Using inactive relationships in a measure.

Power BI – Data Refresh Date

PowerApps – Using JSON Function to save Pictures