Gantt: Dynamic analytics

You can also use DAX measures to plot reference bands. A DAX-driven reference band is used to overlay contextual time ranges on top of a Gantt chart without modifying the underlying tasks. This enables dynamic and user-driven insights that cannot be achieved with static data alone.

We'll look at how to set up dynamic analytics in Analytics+

1

Create a DAX measure to hold reference dates and text. Assign it to the Gantt visual parameter.

DAX measure added to the Gantt chart

2

Assign the DAX measure to the Dynamic analytics data well in the Pivot data window. You'll notice that reference bands and text, based on your DAX measure, are automatically plotted.

Reference bands and text plotted based on the DAX measure

3

The Dynamic Analytics button will now be enabled in the Story section of the Gantt ribbon. Click the button to open the customization side pane.

The Dynamic Analytics button will be enabled only after assigning a DAX measure to the Dynamic analytics data well in the Pivot Data window.

Dynamic analytics customization window

4

Customize the background fill and format the text from the side pane. The customization options are covered in the Analytics section.

Dynamic analytics customization