ADX dashboards November 2021 updates

Published Nov 11 2021 12:34 PM 1,363 Views
Microsoft

ADX dashboards November 2021 updates

Slice and dice

Cross filtering

We’re happy to announce the first release of a new cross filter capability to easily filter dashboard pages by interacting with the visual data points.

Cross filter is defined per visual and serves as a new way to interact with the dashboard by selecting data points in a tile and assigning the data point value to a dashboard filter in the current dashboard page.

It is achieving the same outcome as entering a value in a dashboard page filter, but in a more intuitive way as part of ad-hoc exploration of the dashboard data.

Cross filter is supported for the majority of visual types and allows defining a single interaction and cross filter per visual.

To create a cross filter, enter tile editing screen and open the “Interactions” tab in the visual formatting right pane.

GabiLehner_0-1636662651108.png

 

You need to configure a pair of a column (that provides the value) and a parameter (it feeds). Make sure the column and the parameter selected are of the same data type.

Now you’re all set to interactively explore your dashboard, filtering the data intuitively and efficiently.

GabiLehner_0-1636662769913.gif

Page level filters

It is now possible to set filters to specific pages and not only in the dashboard level.

This means you can create a set of parameters in the scope of the dashboard and decide where to use each one of them. Some you can totally disable in the dashboard, others you can use as filters in the scope of the entire dashboard and a third group of parameters can be used as filters only in specific dashboard pages.

Use the “Show on pages” control to specify where to use the filters.

 

GabiLehner_1-1636662651113.png

 


Control filter ordering

Many of you have been asking for better control of filter ordering in dashboards.

Now you achieve this by using the “Move to” option on the parameters right pane or by simply dragging and dropping the parameter card.

GabiLehner_2-1636662651116.png

 

Visualizations

Map visual updates

You’ve been asking us to get more out of the map visual and we have been listening.

With the new map visual, it is not required anymore, to provide a strict 4 columns result-set structure.

You can use any result set and flexibly select how to provide the location data. You can use either a point column or a pair of latitude and longitude columns.

It is now possible also to dynamically set the bubble size using the data in the result set. Select a numeric column to define the size.

GabiLehner_3-1636662651122.png

 

GabiLehner_0-1636882812022.png

 

ADX dashboards team is looking forward for your feedback in KustoWebExpFeedback@service.microsoft.com

You’re also welcome to add more ideas and vote for them here - https://aka.ms/adx.ideas

ADX dashboards team

%3CLINGO-SUB%20id%3D%22lingo-sub-2956518%22%20slang%3D%22en-US%22%3EADX%20dashboards%20November%202021%20updates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2956518%22%20slang%3D%22en-US%22%3E%3CH1%20id%3D%22toc-hId-1501823059%22%20id%3D%22toc-hId-1501823120%22%3EADX%20dashboards%20November%202021%20updates%3C%2FH1%3E%0A%3CH2%20id%3D%22toc-hId--2102582763%22%20id%3D%22toc-hId--2102582702%22%3ESlice%20and%20dice%3C%2FH2%3E%0A%3CH3%20id%3D%22toc-hId--1412021289%22%20id%3D%22toc-hId--1412021228%22%3ECross%20filtering%3C%2FH3%3E%0A%3CP%3EWe%E2%80%99re%20happy%20to%20announce%20the%20first%20release%20of%20a%20new%20cross%20filter%20capability%20to%20easily%20filter%20dashboard%20pages%20by%20interacting%20with%20the%20visual%20data%20points.%3C%2FP%3E%0A%3CP%3ECross%20filter%20is%20defined%20per%20visual%20and%20serves%20as%20a%20new%20way%20to%20interact%20with%20the%20dashboard%20by%20selecting%20data%20points%20in%20a%20tile%20and%20assigning%20the%20data%20point%20value%20to%20a%20dashboard%20filter%20in%20the%20current%20dashboard%20page.%3C%2FP%3E%0A%3CP%3EIt%20is%20achieving%20the%20same%20outcome%20as%20entering%20a%20value%20in%20a%20dashboard%20page%20filter%2C%20but%20in%20a%20more%20intuitive%20way%20as%20part%20of%20ad-hoc%20exploration%20of%20the%20dashboard%20data.%3C%2FP%3E%0A%3CP%3ECross%20filter%20is%20supported%20for%20the%20majority%20of%20visual%20types%20and%20allows%20defining%20a%20single%20interaction%20and%20cross%20filter%20per%20visual.%3C%2FP%3E%0A%3CP%3ETo%20create%20a%20cross%20filter%2C%20enter%20tile%20editing%20screen%20and%20open%20the%20%E2%80%9CInteractions%E2%80%9D%20tab%20in%20the%20visual%20formatting%20right%20pane.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22GabiLehner_0-1636662651108.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326458iE451F372E95FD5C4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22GabiLehner_0-1636662651108.png%22%20alt%3D%22GabiLehner_0-1636662651108.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20need%20to%20configure%20a%20pair%20of%20a%20column%20(that%20provides%20the%20value)%20and%20a%20parameter%20(it%20feeds).%20Make%20sure%20the%20column%20and%20the%20parameter%20selected%20are%20of%20the%20same%20data%20type.%3C%2FP%3E%0A%3CP%3ENow%20you%E2%80%99re%20all%20set%20to%20interactively%20explore%20your%20dashboard%2C%20filtering%20the%20data%20intuitively%20and%20efficiently.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22GabiLehner_0-1636662769913.gif%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326461i0206BB959AA3CBAB%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22GabiLehner_0-1636662769913.gif%22%20alt%3D%22GabiLehner_0-1636662769913.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1075491544%22%20id%3D%22toc-hId-1075491605%22%3EPage%20level%20filters%3C%2FH3%3E%0A%3CP%3EIt%20is%20now%20possible%20to%20set%20filters%20to%20specific%20pages%20and%20not%20only%20in%20the%20dashboard%20level.%3C%2FP%3E%0A%3CP%3EThis%20means%20you%20can%20create%20a%20set%20of%20parameters%20in%20the%20scope%20of%20the%20dashboard%20and%20decide%20where%20to%20use%20each%20one%20of%20them.%20Some%20you%20can%20totally%20disable%20in%20the%20dashboard%2C%20others%20you%20can%20use%20as%20filters%20in%20the%20scope%20of%20the%20entire%20dashboard%20and%20a%20third%20group%20of%20parameters%20can%20be%20used%20as%20filters%20only%20in%20specific%20dashboard%20pages.%3C%2FP%3E%0A%3CP%3EUse%20the%20%E2%80%9CShow%20on%20pages%E2%80%9D%20control%20to%20specify%20where%20to%20use%20the%20filters.%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--731962919%22%20id%3D%22toc-hId--731962858%22%3E%26nbsp%3B%3C%2FH3%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22GabiLehner_1-1636662651113.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326457i77D0C3092BED91D1%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22GabiLehner_1-1636662651113.png%22%20alt%3D%22GabiLehner_1-1636662651113.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1755549914%22%20id%3D%22toc-hId-1755549975%22%3E%3CBR%20%2F%3EControl%20filter%20ordering%3C%2FH3%3E%0A%3CP%3EMany%20of%20you%20have%20been%20asking%20for%20better%20control%20of%20filter%20ordering%20in%20dashboards.%3C%2FP%3E%0A%3CP%3ENow%20you%20achieve%20this%20by%20using%20the%20%E2%80%9CMove%20to%E2%80%9D%20option%20on%20the%20parameters%20right%20pane%20or%20by%20simply%20dragging%20and%20dropping%20the%20parameter%20card.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22GabiLehner_2-1636662651116.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326459i6CFC2F63227287DC%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22GabiLehner_2-1636662651116.png%22%20alt%3D%22GabiLehner_2-1636662651116.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH1%20id%3D%22toc-hId--752969127%22%20id%3D%22toc-hId--752969066%22%3EVisualizations%3C%2FH1%3E%0A%3CH2%20id%3D%22toc-hId--62407653%22%20id%3D%22toc-hId--62407592%22%3EMap%20visual%20updates%3C%2FH2%3E%0A%3CP%3EYou%E2%80%99ve%20been%20asking%20us%20to%20get%20more%20out%20of%20the%20map%20visual%20and%20we%20have%20been%20listening.%3C%2FP%3E%0A%3CP%3EWith%20the%20new%20map%20visual%2C%20it%20is%20not%20required%20anymore%2C%20to%20provide%20a%20strict%204%20columns%20result-set%20structure.%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20any%20result%20set%20and%20flexibly%20select%20how%20to%20provide%20the%20location%20data.%20You%20can%20use%20either%20a%20point%20column%20or%20a%20pair%20of%20latitude%20and%20longitude%20columns.%3C%2FP%3E%0A%3CP%3EIt%20is%20now%20possible%20also%20to%20dynamically%20set%20the%20bubble%20size%20using%20the%20data%20in%20the%20result%20set.%20Select%20a%20numeric%20column%20to%20define%20the%20size.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22GabiLehner_3-1636662651122.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326460iC7BE4D4A242E5CD9%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22GabiLehner_3-1636662651122.png%22%20alt%3D%22GabiLehner_3-1636662651122.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22GabiLehner_0-1636882812022.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326925iC4BF1447D3972B18%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22GabiLehner_0-1636882812022.png%22%20alt%3D%22GabiLehner_0-1636882812022.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EADX%20dashboards%20team%20is%20looking%20forward%20for%20your%20feedback%20in%20%3CA%20href%3D%22mailto%3AKustoWebExpFeedback%40service.microsoft.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EKustoWebExpFeedback%40service.microsoft.com%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EYou%E2%80%99re%20also%20welcome%20to%20add%20more%20ideas%20and%20vote%20for%20them%20here%20-%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Faka.ms%252Fadx.ideas%26amp%3Bdata%3D04%257C01%257Cgabil%2540microsoft.com%257C43f767ad65614ab696ef08d99f87d3df%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637716228566429665%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3D%252FQDVmU03PGyyBRbK6voUtSQ7wxwaQjQs%252B45IZDFqMCI%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Fadx.ideas%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EADX%20dashboards%20team%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2956518%22%20slang%3D%22en-US%22%3E%3CP%3EYou're%20welcome%20to%20read%20the%20blog%20to%20learn%20about%20the%20new%20stuff%20rolling%20out%20in%20Azure%20Data%20Explorer%20dashboards.%3C%2FP%3E%0A%3CP%3EInside%20you'll%20find%20new%20slices%20and%20dice%20capabilities%20and%20also%20some%20updated%20on%20our%20map%20visual.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2956518%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EADX%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Data%20Explorer%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edashboards%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EKusto%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EVisualisation%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Nov 14 2021 01:40 AM
Updated by: