How to Create a Dynamic Reference Band with Set Actions

preview_player
Показать описание
This video show you how to set up a set action to allow the user to create a reference band based on dates that they select in the chart.

  1. Andy Kriebel
  2. tableau tip tuesday
  3. set action
  4. control
  5. interactivity
  6. reference band
Рекомендации по теме
Dynamic Charts That 0:05:33

Dynamic Charts That Update Automatically In Excel - Using OFFSET To Create Dynamic Ranges

Effortlessly Create Dynamic 0:10:15

Effortlessly Create Dynamic Charts in Excel: New Feature Alert!

Dynamic Block For 0:02:11

Dynamic Block For Beginners - AutoCAD

The Basics of 0:18:16

The Basics of Dynamic Content in 15 Minutes

How to build 0:30:37

How to build Dynamic & Interactive Dashboard in EXCEL with Pivot Tables&Charts | Tutorial Ep...

Advanced Excel Tips: 0:14:11

Advanced Excel Tips: How to Create a Dynamic PivotTable Style Report with One Formula

Excel Dynamic Arrays 0:07:01

Excel Dynamic Arrays (How they will change EVERYTHING!)

How to Create 0:12:25

How to Create a Dynamic Chart Range in Excel using Dropdown

Create a dynamically 0:05:27

Create a dynamically deforming spiral of text using After Effects and Newton

How to Create 0:03:25

How to Create Dynamic Named Ranges in Excel

How to Create 0:00:41

How to Create a Dynamic Numbered List in Excel #shorts

Dynamic Block For 0:07:01

Dynamic Block For Beginners - AutoCAD

Create Dynamic Dropdown 0:13:03

Create Dynamic Dropdown Lists in Excel

How to Create 0:17:34

How to Create a DYNAMIC Map Chart With Drop-Down (works with ANY Excel version)

How to Create 0:12:33

How to Create an Excel Interactive Chart with Dynamic Arrays

Build a Dynamic 0:15:22

Build a Dynamic Financial Model in Just 15 Minutes

How to Build 0:32:13

How to Build a Dynamic Website from Scratch with Wordpress FOR FREE

How to Create 0:06:14

How to Create a Dynamic Table on Excel Data Using Power Automate | 2022 Tutorial

Create a Dynamic 0:00:17

Create a Dynamic Heat Map in Excel! #Shorts

How To Create 2:45:36

How To Create A Dynamic Report In Excel From Any Table In ONE CLICK + FREE DOWNLOAD

Create Your Dynamic 0:11:50

Create Your Dynamic Door - AutoCAD

Dynamic Titles in 0:03:27

Dynamic Titles in Power BI Desktop

Adobe Acrobat DC 0:07:34

Adobe Acrobat DC Dynamic Stamp Tutorial

How to build 0:25:43

How to build Dynamic & Interactive Dashboard in EXCEL without VBA | Full Tutorial + Voice-over

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

You're seriously the best for putting these on youtube.

JasonScott
Автор

Thank you for sharing! Is it possible to filter other chart by the selected data set in the refference band? I can't figure this out.

mliwia
Автор

Learning a Lot with you :)
Thanks and Regards

wonderwoman
Автор

Hi Andy. Thanks for this. Do you know if these set action reference lines could be aligned with Pages Shelve time stamp? Lisa Trescott has them in her Iron Viz workbook, but I'm not sure if she's used two worksheets (one on top of the other), or if it is within one worksheet. I'm trying to re-create the latter, but can't see this working with Page Shelve option...

witoldlisicki
Автор

Thanks Andy! May I know how to create dynamic reference band by quarter-year instead of date? I tried to change x-axis, but then the color of selected day period split up along the line (i.e. color is not continuous in the line chart)

marcocheung
Автор

Hey Andy,

Great Video. It doesn't seem to allow me to select my min and max date calcs when creating reference bands??

I can only select parameters. The min and max date calcs are not available in the dropdown. Do you know why this would be the case?

Thanks

matthewlawry