Creating a Calendar Slicer from a Matrix Table! (with Erik Svensen)

preview_player
Показать описание
Join Erik Svensen and I as Erik walks through how to transform a native matrix visual into a powerful Calendar type filter for your visuals! Where you can slice by date, day of week, week period of year, and more. Tune in for the demo!

GUEST BIO 👤
Erik Svensen is a Microsoft MVP. Erik has been working with the Microsoft BI stack for more than 20 years - starting with out with Excel and Microsoft Query for over 25 years ago. He owns the company CatMan Solution who is now serving over 70+ FMCG suppliers with a Power BI solution that provides the supplier with valuable insights in their performance at store level based on point of sales data provided to them by different retailers. He started the Danish Power BI User group and speaks at conferences and meetups. Another great passion besides Power BI is his collection of Danish contemporary art. And if he finds time he occasionally blogs about Power BI as well.

RELATED CONTENT 🔗

BECOME A CHANNEL MEMBER 🎉

CHECK OUT OUR MERCH STORE 👕

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟

HAVENS CONSULTING PAGES 📄

EMAIL US AT 📧

#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel
  1. Havens Consulting
  2. Power BI
  3. PowerBI
  4. PBI
  5. DAX
  6. Data Modeling
Рекомендации по теме
Creating a Calendar 0:24:52

Creating a Calendar Slicer from a Matrix Table! (with Erik Svensen)

Create a Dynamic 0:19:25

Create a Dynamic Calendar Slicer for your Dashboards

Build a DATE 0:10:14

Build a DATE PICKER in Power BI Desktop

Convert Date Range 0:04:22

Convert Date Range Slicer into Calendar Slicer in Power BI | Power BI | Calendar Slicer

How to get 0:08:48

How to get a DATE TABLE easily in Power BI

Custom Date Period 0:10:42

Custom Date Period Selections in Power BI

Create slicer with 0:14:07

Create slicer with Custom Time Periods in PowerBI | Time Intelligence | MiTutorials

CUSTOM PERIOD SLICER 0:05:14

CUSTOM PERIOD SLICER IN POWER BI | CUSTOM DATE SLICER IN POWER BI | DATE RANGE OF YOUR OWN CHOICE

Default dynamic Date 0:10:28

Default dynamic Date Slicer and also custom select Dates in PowerBI | MiTutorials

Power BI - 0:03:55

Power BI - Date Slicer

Excel Slicers containing 0:05:59

Excel Slicers containing Year and Month

How to set 0:09:02

How to set a DATE SLICER to TODAY by default in Power BI

SWITCH SLICER TO 0:06:46

SWITCH SLICER TO TOGGLE BETWEEN CALENDARS | SWITCH BETWEEN CALENDAR YEAR AND FISCAL YEAR IN POWER BI

How to Create 0:08:36

How to Create a SLICER for VALID DATES Only in DAX

Creating a MTD/QTD/YTD 0:09:35

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

How to create 0:06:08

How to create a Calendar slicer and Merged Bar chart in Power BI for Beginners

Create CUSTOM DATE 0:20:21

Create CUSTOM DATE RANGE FILTER for a better USER EXPERIENCE // Beginners Guide to Power BI in 2021

Set a Dynamic/Default/Changing 0:06:17

Set a Dynamic/Default/Changing Date in Power BI Date Slicer

Switch Between Calendar 0:13:10

Switch Between Calendar and Fiscal Year in Power BI

Make Immovable Slicers 0:01:04

Make Immovable Slicers for Pivot Tables - Excel Quickie 101

Filter Pivot Tables 0:09:28

Filter Pivot Tables For Month-to-date Mtd Comparisons With Slicers

Power BI - 0:04:35

Power BI - How to get the Latest Selected Date from Date Slicer in a Field

Create Easy Yearly 0:10:33

Create Easy Yearly Calendar in Excel and Sheets with a SINGLE Formula

Build a Slicer 0:10:32

Build a Slicer Panel in Power BI (2022/2023)

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

there is a custom paid calendar visual called "date picker" which is fantastic. this is really cool for a free alternative!

you can do a pagination effect with the new slicer with single row/max buttons shown X/overflow pagination, with the only problem being when the selected month is outside the range in the page you lose context of what's selected. however the way matrix shows the selected month you could almost get away with the user knowing they have to go forward/back, or maybe as part of a deployment rule in making sure the current month is the default selection. not perfect by any stretch, but options!

lucasshipsides
Автор

Great video Erik thanks for sharing your PBIX calendar with us. However, I noticed when opening your file that the calendar is blank. What am I missing?

DroneEyes
Автор

Hi - great idea and tutorials. I found if i used 3 digit Day names (DD Su Mo Tu We Th Fr Sa ) this bypassed the col width issues as you have corresponding double digit numbers in the table below (and DD still looked good/easy to understand).
Appreciate the Dax trick which makes this work 👍🏽

Bondoz