Avoiding DAX: Using Dynamic Arrays to create Interactive Visuals | Jessica Slack

In this session, Jess will share some examples of “Power BI style” interactive visualisations that are created using dynamic arrays.

If you want to give users the ability to interact graphically with your data but you don’t want to learn DAX or Power BI, this session is for you.

Dynamic array formulas have opened up lots of new opportunities for us to design interactivity into our graphs – for example, to allow our users to filter, segment or cluster data as they want to see it.

The session will contain practical examples of dashboard components and will feature a mix of older and newer Excel functionality; expect Slicers, Checkboxes and LAMBDAs, along with some graphing tricks to get the most out of them. Whether you are new to dynamic arrays or already experienced with them, there should be something in this session for you.

This will be an in-person only event.

The event will be held at:
Meeting room 3,
Canada Water Library,
21 Surrey Quays Rd, London SE16 7AR