https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Deneb-Facet-Cross-Filtering-Demo-A-Field-Guide-to-Red-and-Blue/m-p/2181673#M6154 <P>This started as an experiment with the <A href="https://deneb-viz.github.io/" target="_self">Deneb</A> custom visual, to see how well the Vega-Lite's faceting functionality worked with the dataset behind the main visual by Randy Yeip, Stuart A. Thompson and Will Welch in <A href="http://graphics.wsj.com/elections/2016/field-guide-red-blue-america/" target="_self">this Wall Street Journal article</A> on the 2016 US election.</P> <P>Once I wired-up the base visual (and the legend visual explaining the PVI Score, which also uses Deneb), I started to think about how well cross-filtering integration may work at both the data point and the facet level, so did a bit more work to illustrate that the matrix in the same page could be cross-filtered accordingly (or through a combination of either, plus multi-selection with the Ctrl key).</P> <P>Bookmarks were then added, to illustrate that selection state can also be saved and recalled, so this opens up storytelling potential a little further.</P> <P>The core visual is a single Deneb/Vega-Lite specification, using the following fields:</P> <UL> <LI>State:&nbsp;the column we want to facet by</LI> <LI>MapX: the x-coordinate of the state</LI> <LI>MapY: The y-coordinate of the state</LI> <LI>Year: the election year, and series of the x-axis for each facet chart (format : <FONT face="courier new,courier">'YY</FONT>)</LI> <LI>Year Sort: a column added during transformation to ensure that years sort nicely (note that Vega-Lite does let us prescribe a manual sort order, but this simplifies the data-driving of such a field)</LI> <LI>Inclination: how Replublican or Democratic each state is for a given election year</LI> <LI>PVI Score: the partisan voter index (how much the inclination leans relative to the nation overall)&nbsp;</LI> </UL> <P>As .json files can't be attached to Data Stories, the Deneb template is <A href="https://gist.github.com/dm-p/14391de90a021e8965c26aa20de480ab" target="_self">available in this Gist</A> (or can be inspected/modified in the attached workbook).</P> <P>&nbsp;</P> <P><SPAN class="reportid hidden">eyJrIjoiZjgwYTJiZDktMDY1YS00ZjM1LWEwZWUtM2FkOTU3ZWYzOWYxIiwidCI6IjUzYmJlMGQ3LTU0NzItNGQ0NS04NGY0LWJiNzJiYjFjMjI4OSJ9</SPAN></P> Wed, 10 Nov 2021 02:54:42 GMT dm-p 2021-11-10T02:54:42Z https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Deneb-Facet-Cross-Filtering-Demo-A-Field-Guide-to-Red-and-Blue/m-p/2181673#M6154 <P>This started as an experiment with the <A href="https://deneb-viz.github.io/" target="_self">Deneb</A> custom visual, to see how well the Vega-Lite's faceting functionality worked with the dataset behind the main visual by Randy Yeip, Stuart A. Thompson and Will Welch in <A href="http://graphics.wsj.com/elections/2016/field-guide-red-blue-america/" target="_self">this Wall Street Journal article</A> on the 2016 US election.</P> <P>Once I wired-up the base visual (and the legend visual explaining the PVI Score, which also uses Deneb), I started to think about how well cross-filtering integration may work at both the data point and the facet level, so did a bit more work to illustrate that the matrix in the same page could be cross-filtered accordingly (or through a combination of either, plus multi-selection with the Ctrl key).</P> <P>Bookmarks were then added, to illustrate that selection state can also be saved and recalled, so this opens up storytelling potential a little further.</P> <P>The core visual is a single Deneb/Vega-Lite specification, using the following fields:</P> <UL> <LI>State:&nbsp;the column we want to facet by</LI> <LI>MapX: the x-coordinate of the state</LI> <LI>MapY: The y-coordinate of the state</LI> <LI>Year: the election year, and series of the x-axis for each facet chart (format : <FONT face="courier new,courier">'YY</FONT>)</LI> <LI>Year Sort: a column added during transformation to ensure that years sort nicely (note that Vega-Lite does let us prescribe a manual sort order, but this simplifies the data-driving of such a field)</LI> <LI>Inclination: how Replublican or Democratic each state is for a given election year</LI> <LI>PVI Score: the partisan voter index (how much the inclination leans relative to the nation overall)&nbsp;</LI> </UL> <P>As .json files can't be attached to Data Stories, the Deneb template is <A href="https://gist.github.com/dm-p/14391de90a021e8965c26aa20de480ab" target="_self">available in this Gist</A> (or can be inspected/modified in the attached workbook).</P> <P>&nbsp;</P> <P><SPAN class="reportid hidden">eyJrIjoiZjgwYTJiZDktMDY1YS00ZjM1LWEwZWUtM2FkOTU3ZWYzOWYxIiwidCI6IjUzYmJlMGQ3LTU0NzItNGQ0NS04NGY0LWJiNzJiYjFjMjI4OSJ9</SPAN></P> Wed, 10 Nov 2021 02:54:42 GMT https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Deneb-Facet-Cross-Filtering-Demo-A-Field-Guide-to-Red-and-Blue/m-p/2181673#M6154 dm-p 2021-11-10T02:54:42Z https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Deneb-Facet-Cross-Filtering-Demo-A-Field-Guide-to-Red-and-Blue/m-p/2183808#M6158 <P>Nice work. <BR />Thanks for sharing <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 10 Nov 2021 21:08:31 GMT https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Deneb-Facet-Cross-Filtering-Demo-A-Field-Guide-to-Red-and-Blue/m-p/2183808#M6158 Icad01 2021-11-10T21:08:31Z