In this article I show methods to calculate the doubling time with DAX in Power BI. Doubling time is an indicator used for exponential growth scenarios. It indicates how much (…) Read more
Posts Tagged ‘Charting’
How to use regular charts on dynamic pivot tables in Excel
There are many good reasons not to use Pivot charts as described in this article i.e. – one I would like to add is the bug when using “invert if negative”: (…) Read more
Report Design with Power Query (1): Cascading Time Granularities
Cascading Time Granularities When the client is not happy with the pivot report layout options on cubes in Excel, my usual reaction is “OK no problem, then we’re going to (…) Read more
Waterfall Chart using Power Query
How to create a Waterfall Chart using Power Query? Target is a chart like above: Starting point, several movements & then an ending sum. Every movement starts at the end of (…) Read more