Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

jterh1

SandDance Power BI Custom Visual updates

SandDance is a data visualization tool developed by the VIDA (Visualization and Interactive Data Analysis) team at Microsoft Research and is available as a custom visual for Power BI. SandDance uses unit visualizations, which apply a one-to-one mapping between rows in your data and marks on the screen. Smooth animated transitions between views help you to maintain context as you interact with your data. These animations are one of its most compelling aspects yet are currently only visible to the report designer – not to casual report viewers.

The VIDA team has made significant updates to the SandDance 2019 custom visual. We’ve enhanced the ability to deliver richer and more compelling data-driven stories, both by adding support for Power BI bookmarks and making significant improvements to the rendering capabilities.

Support for Power BI bookmarks

We have now added the ability to save the state of a SandDance view as a Power BI bookmark. This includes the layout (such as a scatterplot, unit bar, column chart or stacked 3D), selection, and filter. This significantly enhances the storytelling capabilities for a Power BI report that uses SandDance by enabling dynamic transitions between a series of Power BI bookmarks and provides better context and narrative to the data (commonly known as ‘data storytelling’).

https://youtu.be/Nzhij3bbmZ8

Support for richer transitions

In the current version of SandDance during an animated transition, all data points begin animating simultaneously. We now support the ability to customize the order in which each datapoint transitions between views. We call these staggered transitions.

Animation_of_SandDance_chart_elements_changing_layout_positions_in_separate_moveAnimation_of_SandDance_chart_elements_changing_layout_positions_in_separate_move

Support for background images

You can now use an image as the background of a Scatterplot or Stacks chart to help provide additional context to the visualization.

This example is a Scatterplot showing house sales data for King County, WA.

Screenshot_of_bar_chart_elements_overlaid_on_a_map_of_the_Puget_Sound_region_inScreenshot_of_bar_chart_elements_overlaid_on_a_map_of_the_Puget_Sound_region_in

This example is a Stacks plot of the positions of shots made on a basketball court by Kobe Bryant, who was a professional basketball player for the Los Angeles Lakers team.

Screenshot_of_stacked_elements_overlaid_on_an_image_of_a_basketball_court_in_SanScreenshot_of_stacked_elements_overlaid_on_an_image_of_a_basketball_court_in_San

New rendering engine

We’ve completely re-engineered our WebGL rendering engine. It has two modes:
  1. Standard mode can handle many data points while still being responsive and works on mobile devices and lower power GPUs .
  2. Enhanced 3D mode adds shadows, emissive lighting, and depth of field effects, and requires a more powerful GPU.
The rendering engine also now supports stereo rendering and immersive Virtual Reality experiences using WebXR.

The following examples compare the two rendering modes. In each image, the same visualization is shown using both the standard rendering mode (top half) and enhanced 3D rendering mode (bottom half).

Screenshots_of_two_chart_renderings_in_SandDance_above_is_a_standard_bar_chart_3Screenshots_of_two_chart_renderings_in_SandDance_above_is_a_standard_bar_chart_3

Shadows can be used to help convey depth in 3D visualizations, such as in the following examples.

Screenshots_of_two_chart_renderings_each_overlaid_on_a_map_of_Puget_Sound_in_SanScreenshots_of_two_chart_renderings_each_overlaid_on_a_map_of_Puget_Sound_in_San

Screenshots_of_two_chart_renderings_in_SandDance_above_is_a_standard_bar_chart_3Screenshots_of_two_chart_renderings_in_SandDance_above_is_a_standard_bar_chart_3

Emissive lighting can be used to emphasize selections, such as in the following examples.

Screenshots_of_two_chart_renderings_with_selected_elements_in_SandDance_above_shScreenshots_of_two_chart_renderings_with_selected_elements_in_SandDance_above_sh

Screenshots_of_two_chart_renderings_each_overlaid_on_a_map_of_Puget_Sound_in_SanScreenshots_of_two_chart_renderings_each_overlaid_on_a_map_of_Puget_Sound_in_San

 

Depth of field can also be used to emphasize and draw attention to specific areas of 3D visualizations, such as in the following examples.

Screenshots_of_two_chart_renderings_each_overlaid_on_a_map_of_Puget_Sound_in_SanScreenshots_of_two_chart_renderings_each_overlaid_on_a_map_of_Puget_Sound_in_San

 

Screenshots_of_two_chart_renderings_each_overlaid_on_an_image_of_a_basketball_coScreenshots_of_two_chart_renderings_each_overlaid_on_an_image_of_a_basketball_co

Adaptive 3D chart axes

In a 3D view, axes now adapt to the viewing angle, ensuring they are always visible without obscuring the data:

Animation_of_a_3D_SandDance_chart_rotating_showing_axes_which_appear_or_disappeaAnimation_of_a_3D_SandDance_chart_rotating_showing_axes_which_appear_or_disappea

 

New selection modes

As well as using the axis edge divisions and labels, you can now also make selections via the axes background grid squares:

Animation_showing_selections_made_by_clicking_on_grid_cells_in_a_SandDance_visuaAnimation_showing_selections_made_by_clicking_on_grid_cells_in_a_SandDance_visua

We have also now added lasso selection, using the ALT key with a mouse drag:

Screenshot_of_scatterplot_chart_with_a_rectangular_mouse_selection_area_in_SandDScreenshot_of_scatterplot_chart_with_a_rectangular_mouse_selection_area_in_SandD

Release timeline

Watch for these features to be released in summer 2022.

If you have any feedback on these new features, or any new capabilities you’d like to see in the future, please send us an email. You can also track issues at the SandDance GitHub repo.