Posts filed under Power BI

Additional Date Period Filters for the Time Intelligence Slicer

Video by: Reid Havens

Part three of four in a series. Building upon the two previous videos where I showed how to create a Time Intelligence Slicer. This video adds date ranges for prior month-to-date, prior quarter-to-date, and prior year-to-date.

RELATED CONTENT ๐Ÿ”—

Part 1: Creating MTD/QTD/YTD Slicer
Part 2: Applying USERELATIONSHIP Function
Part 4: Fiscal Periods

Applying the USERELATIONSHIP Function on a Time Intelligence Slicer

Video by: Reid Havens

Part two of four in a series. Learn how to leverage the USERELATIONSHIP function in DAX to apply time intelligence date filtering only to selected measures.

RELATED CONTENT ๐Ÿ”—

Part 1: Creating MTD/QTD/YTD Slicer
Part 3: Additional Date Periodsโ€‹
Part 4: Fiscal Periods

Creating a MTD/QTD/YTD Time Intelligence Slicer in Power BI

Video by: Reid Havens

Part one of four in a series. Learn how to leverage relationships and DAX calculated tables to create a time intelligence slicer in Power BI. The end result will perform faster and create a better user experience versus creating lots of unique time intelligence DAX measures.

RELATED CONTENT ๐Ÿ”—

Part 2: Applying USERELATIONSHIP Function
Part 3: Additional Date Periodsโ€‹
Part 4: Fiscal Periods

New Pages Added to my Google Analytics Report!

Video by: Reid Havens

Learn about the two new pages I added to my Google Analytics Report. One page is dedicated to the new Decomposition visual just released in Power BI desktop. The other page is dedicated to site speed information. More information about the decomposition tree can be read below.

NOTE: to use the decomposition tree, you need to enable that visual in the preview settings in the options menu.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-decomposition-tree

Posted on December 31, 2019 and filed under Beginner, Power BI.