How To Dynamically Select Starting Period For Any Chart In Power BI

preview_player
Показать описание
In today's tutorial, Brian will be doing a follow up to a short series dealing with troubles and issues that you might encounter with Time Intelligence particularly on the week granularity. For this video, Brian will demonstrate how you can take a visual and vary it dynamically on the start date.

***** Video Details *****
00:00 Introduction
02:30 Data model
04:23 Rubber duck
05:59 Within range monthly
08:35 Within range weekly wrong
11:15 Within range weekly
14:18 Wk1Offset

***** Learning Power BI? *****

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #TimeIntelligence
  1. Enterprise DNA
  2. Power BI
  3. Power BI DAX
  4. Enterprise DNA
  5. Power BI Tutorial
  6. Power BI tutorial for beginners
Рекомендации по теме
How To Dynamically 0:18:41

How To Dynamically Select Starting Period For Any Chart In Power BI

LAST N MONTHS 0:07:47

LAST N MONTHS WITH SELECTED MEASURES IN POWER BI | DYNAMICALLY SELECT PAST N MONTHS WITH ANY MEASURE

Select Columns that 0:01:28

Select Columns that starts with a given Prefix in Power Query Dynamically

How to DYNAMICALLY 0:05:19

How to DYNAMICALLY Select a Table in the List Rows Present in a Table Power Automate Action

Display columns dynamically 0:03:05

Display columns dynamically using a Slicer in PowerBI | Tutorial | MiTutorials

Excel Pro Tricks: 0:00:50

Excel Pro Tricks: Dynamically Filter Data based on Month with FILTER function in Excel Formula

How To Choose 0:03:35

How To Choose columns in a Table dynamically with Slicer in Power BI | BI Tricks

Excel OFFSET Function 0:14:15

Excel OFFSET Function for Dynamic Calculations - Explained in Simple Steps

Dynamically Find a 0:05:28

Dynamically Find a Column Header in Power Query | Dynamically Select Column Header In Power Query

Dynamically Populate Google 0:04:44

Dynamically Populate Google Form's Dropdown using Google Sheets #googlesheets #googleform

Dynamically select columns 0:10:13

Dynamically select columns in a VLOOKUP formula

Dynamically find min 0:00:45

Dynamically find min and max values in Excel - Excel Tips and Tricks

Dynamically expanding specific 1:31:40

Dynamically expanding specific columns & Optimizing code with nested let - #SaturdayWithPowerQue...

Dynamically Filter Data 0:01:00

Dynamically Filter Data LIKE A PRO with Excel's Filter Function

Excel Dynamic Arrays 0:07:01

Excel Dynamic Arrays (How they will change EVERYTHING!)

Dynamically Highlight Specific 0:00:39

Dynamically Highlight Specific Rows - Excel Tips and Tricks

Filter Data Dynamically 0:01:00

Filter Data Dynamically With Excel FILTER Function - Excel Tips and Tricks

How to LIMIT 0:03:59

How to LIMIT ROWS Dynamically in Power Query | Power BI

Sum columns dynamically 0:01:01

Sum columns dynamically without using subtotal columns #dynamic #exceltips #exceltutorial #filter

Excel Quick Tip: 0:01:31

Excel Quick Tip: How to Make Charts Auto Update

Extract UNIQUE Items 0:14:49

Extract UNIQUE Items for Dynamic Data Validation Drop Down List

Dynamically remove columns 0:05:51

Dynamically remove columns in Power Query

Dynamically Mask Cell 0:01:00

Dynamically Mask Cell Contents with Asterisk - Excel Tips and Tricks

Dynamically Re-Order Columns 0:07:57

Dynamically Re-Order Columns in Power Query

Комментарии
Автор

Great topic! Thanks for demonstrating. Thumbs up!!

wayneedmondson
Автор

Thanks Brian. As ever, a great explanation.

EricaDyson
Автор

How did you create the monthoffset field for the formula

grantstoppa
Автор

Hi, that is great!!! Would you be able to share a PowerBi file with that calculation?

piotr
Автор

Where can we download the file to see how this works. I've tried to replicate but I'm missing something.

eugenenel
Автор

The first part of monthly where you create the SelYr and SelMon variables. Do you have to make a selection on these to make this work? I can’t seem to manage

AlYoung
Автор

Is there also a way for this chart to show also the historical line at the same time?

mhikeangelogeluz
Автор

This is a unique situation where sisense has better features than Power BI. I prefer Power BI but sometimes Sisense does it right.

culpritdesign