<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Waffle chart by DAX in Custom Visuals Development Discussion</title>
    <link>https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Waffle-chart-by-DAX/m-p/2269623#M4193</link>
    <description>&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="wujunmin_4-1641480105165.png" style="width: 400px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/652031iB3B8E31C2F59F9BF/image-size/medium?v=v2&amp;amp;px=400" role="button" title="wujunmin_4-1641480105165.png" alt="wujunmin_4-1641480105165.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Matrix&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="wujunmin_2-1641480000972.png" style="width: 400px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/652029i37E03029CB06623A/image-size/medium?v=v2&amp;amp;px=400" role="button" title="wujunmin_2-1641480000972.png" alt="wujunmin_2-1641480000972.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Card&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You only need a measure and mark it as image URL：&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;SVGChart =
VAR t=GENERATESERIES(1,10)
VAR tPlus=GENERATE(SELECTCOLUMNS(t,"Value1",[Value]),t)
VAR tPlusPlus=ADDCOLUMNS(tPlus,"Index",RANKX(tPlus,[Value]+[Value1]/100,,ASC))
VAR tWaffle=ADDCOLUMNS(tPlusPlus,"circle","&amp;lt;circle cx='"&amp;amp;[Value]*10-5&amp;amp;"' cy='"&amp;amp;[Value1]*10-5 &amp;amp;"' r='4' fill='"&amp;amp;IF([Index]&amp;lt;=ROUND([KPI]*100,0),"Grey","LightGrey")&amp;amp;"' fill-opacity='0.4'/&amp;gt;")
VAR Chart=
"data &amp;amp;colon;image/svg+xml;utf8,"&amp;amp;"
&amp;lt;svg xmlns='http://www.w3.org/2000/svg' height='100' width='100'&amp;gt;"&amp;amp;
CONCATENATEX(tWaffle,[circle])&amp;amp;"
&amp;lt;!-- Data label --&amp;gt;
&amp;lt;text x='50' y='50' font-size='25' text-anchor='middle' dominant-baseline='middle' fill='"&amp;amp; IF([KPI]&amp;gt;=0.3,"DarkCyan","Tomato")&amp;amp;"'&amp;gt;"&amp;amp;ROUND([KPI]*100,0)&amp;amp;"%"&amp;amp;"&amp;lt;/text&amp;gt;
&amp;lt;/svg&amp;gt; "
Return
IF(HASONEVALUE('Table'[StoreID]),Chart,BLANK())&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Thu, 06 Jan 2022 14:53:03 GMT</pubDate>
    <dc:creator>wujunmin</dc:creator>
    <dc:date>2022-01-06T14:53:03Z</dc:date>
    <item>
      <title>Waffle chart by DAX</title>
      <link>https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Waffle-chart-by-DAX/m-p/2269623#M4193</link>
      <description>&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="wujunmin_4-1641480105165.png" style="width: 400px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/652031iB3B8E31C2F59F9BF/image-size/medium?v=v2&amp;amp;px=400" role="button" title="wujunmin_4-1641480105165.png" alt="wujunmin_4-1641480105165.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Matrix&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="wujunmin_2-1641480000972.png" style="width: 400px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/652029i37E03029CB06623A/image-size/medium?v=v2&amp;amp;px=400" role="button" title="wujunmin_2-1641480000972.png" alt="wujunmin_2-1641480000972.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Card&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You only need a measure and mark it as image URL：&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;SVGChart =
VAR t=GENERATESERIES(1,10)
VAR tPlus=GENERATE(SELECTCOLUMNS(t,"Value1",[Value]),t)
VAR tPlusPlus=ADDCOLUMNS(tPlus,"Index",RANKX(tPlus,[Value]+[Value1]/100,,ASC))
VAR tWaffle=ADDCOLUMNS(tPlusPlus,"circle","&amp;lt;circle cx='"&amp;amp;[Value]*10-5&amp;amp;"' cy='"&amp;amp;[Value1]*10-5 &amp;amp;"' r='4' fill='"&amp;amp;IF([Index]&amp;lt;=ROUND([KPI]*100,0),"Grey","LightGrey")&amp;amp;"' fill-opacity='0.4'/&amp;gt;")
VAR Chart=
"data &amp;amp;colon;image/svg+xml;utf8,"&amp;amp;"
&amp;lt;svg xmlns='http://www.w3.org/2000/svg' height='100' width='100'&amp;gt;"&amp;amp;
CONCATENATEX(tWaffle,[circle])&amp;amp;"
&amp;lt;!-- Data label --&amp;gt;
&amp;lt;text x='50' y='50' font-size='25' text-anchor='middle' dominant-baseline='middle' fill='"&amp;amp; IF([KPI]&amp;gt;=0.3,"DarkCyan","Tomato")&amp;amp;"'&amp;gt;"&amp;amp;ROUND([KPI]*100,0)&amp;amp;"%"&amp;amp;"&amp;lt;/text&amp;gt;
&amp;lt;/svg&amp;gt; "
Return
IF(HASONEVALUE('Table'[StoreID]),Chart,BLANK())&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 06 Jan 2022 14:53:03 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Waffle-chart-by-DAX/m-p/2269623#M4193</guid>
      <dc:creator>wujunmin</dc:creator>
      <dc:date>2022-01-06T14:53:03Z</dc:date>
    </item>
  </channel>
</rss>

