Posts filed under Power BI

Custom KPI Card with Color Status Bar and Details

Video by: Reid Havens

Learn how to combine two visuals to create a KPI card with a value, conditionally formatted status bar, and details label at the bottom.

Download Report from the Blog Files Page
Posted on April 21, 2020 by Reid Havens and filed under Intermediate, Power BI, Visualizations, Design & Presentation and tagged Layered Visuals Conditional Formatting.

NEW! DAX Coalesce Function in Power BI

Video by: Reid Havens

Learn about the newly added DAX Coalesce function in Power BI Desktop. This function enables users to easily add multi-step conditional logic when accounting for BLANK values in a measure.

Download Report From The Blog Files Page
Posted on March 17, 2020 by Reid Havens and filed under DAX, Beginner, Power BI and tagged DAX Functions Beginner DAX.

NEW! Native Hierarchy Slicer in Power BI

Video by: Reid Havens

Learn about the newly added Hierarchy slicer option for the native slicer visual in Power BI

Download Report From The Blog Files Page
Posted on February 25, 2020 by Reid Havens and filed under Beginner, Power BI, Power BI Features, Slicers & Filters and tagged Slicers Native Visuals.

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

Posted on February 18, 2020 by Reid Havens and filed under Intermediate, Performance/Optimization, Power BI, Slicers & Filters, DAX and tagged Slicers Time Intelligence Intermediate DAX.