Notes on Power BI, Fabric and AI.

Power BI

Power BI Feature Spotlight: Using Bookmark Buttons to Create Pop-Up Windows

Hello P3 Adaptive Nation, welcome back to another exciting month of Power BI updates! This month’s release saw quite a few new updates and enhancements to the Power BI Universe.

Read the article

Power BI

PBI Spotlight: NEW & IMPROVED Tooltips

Hello again P3 Adaptive Nation! I’m SUPER excited today to talk about an updated feature in Power BI Desktop.

Read the article

Power BI

How to Connect One Slicer to All Your Power BI Report Pages

And another one bites the dust… this month the Power BI team have only delivered the #1 most requested feature on the Power BI Ideas forum.

Read the article

Power BI

Using SELECTEDVALUES To Capture Power BI Slicer Selections

Hello P3 Adaptive Nation, I’m excited to be back and writing a technical post again…it’s been too LONG!

Read the article

Power BI

Months and Trailing Twelve Months in One Table

Trailing twelve months (TTM) Power BI. Show each month and total trailing twelve months (TTM), the total for prior TTM, AND the variance in one table.

Read the article

Power BI

A Star (Schema) and a SWITCH for Drill-Down Income Statement Design

When I was first introduced to PowerPivot five or six years ago, I knew it would serve me well in my FP&A function.

Read the article

Power BI

Power Query (M)agic: Consecutive Days

Hello P3 Adaptive World! My name is Krissy Dyess and I have had the most amazing experience working as a full-time consultant at Power Pivot Pro since April 17, 2017!

Read the article

Power BI

Dynamic Attributes In A Power BI Report

Dynamic attributes and how to implement them in Power BI Desktop or Power Pivot using “Harvester” measures and disconnected slicers.

Read the article

Power BI

SUMMARIZE() & ADDCOLUMNS() aren’t scary… if you can SEE them!

I tried solving this problem and the internet led me to SUMMARIZE(). It was stuffed inside another function and it confused me

Read the article

Data Strategy

On the Right PATH() – A DAX/Power Query approach to working with parent/child hierarchies.

One of my colleagues and I have been geeking out the last few years over all things Power (Query, Pivot, View, and now BI).

Read the article

Power BI

Jittered Scatter Charts in Power BI via DAX and Power Query

In a recent post, I hinted that I’d be using the Football Project V2 as my “platform” for some future techniques-oriented posts. T

Read the article

Power BI

Power BI (DAX and M) vs. R: A Summer of Perspective

Based on what I’ve learned from Zoe, and what I’ve read to fill in the gaps, I think the two big differentiators are “how much statistical rigor do you require” and “how many different variations of the question do you need to ask?”

Read the article