topic Re: Percent Difference between two visuals utilizing slicers and two different tables in Developer https://community.fabric.microsoft.com/t5/Developer/Percent-Difference-between-two-visuals-utilizing-slicers-and-two/m-p/4779509#M62388 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/1323500">@JCATERINO</a>&nbsp;,</P> <P>Thanks for reaching out to the Microsoft fabric community forum.</P> <P>&nbsp;</P> <P data-start="206" data-end="460">Could you please provide sample data that fully represents the issue or question you're referring to? Kindly ensure the data is in a usable format (e.g., Excel or CSV) rather than a screenshot, and does not contain any sensitive or unrelated information.</P> <P data-start="462" data-end="495">Looking forward to your response.</P> <P data-start="497" data-end="533"><STRONG>Best regards,</STRONG><BR data-start="510" data-end="513" /><STRONG data-start="513" data-end="533">Lakshmi Narayana</STRONG></P> Tue, 29 Jul 2025 07:30:27 GMT v-lgarikapat 2025-07-29T07:30:27Z Percent Difference between two visuals utilizing slicers and two different tables https://community.fabric.microsoft.com/t5/Developer/Percent-Difference-between-two-visuals-utilizing-slicers-and-two/m-p/4779220#M62386 <P>Can someone please help:</P><P>1. I created two tables that are filtered by several slicers - Month, Year, Site and Class of Work</P><P>2. Both cards display the distinct count of Orders completed based on the slicers</P><P>3. I would like to create a visual card that calculated the percent difference between the two cards</P><P>&nbsp;</P><P>Example</P><P>First Card returns 352 orders for 2025, Site A, Class of Work A</P><P>Second Card returns 645 orders for 2024, Site A, Class of Work A</P><P>&nbsp;</P><P>I would like to calculate the percent difference based on the slicers so it would filter dynamically.</P> Tue, 29 Jul 2025 01:30:35 GMT https://community.fabric.microsoft.com/t5/Developer/Percent-Difference-between-two-visuals-utilizing-slicers-and-two/m-p/4779220#M62386 JCATERINO 2025-07-29T01:30:35Z Re: Percent Difference between two visuals utilizing slicers and two different tables https://community.fabric.microsoft.com/t5/Developer/Percent-Difference-between-two-visuals-utilizing-slicers-and-two/m-p/4779509#M62388 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/1323500">@JCATERINO</a>&nbsp;,</P> <P>Thanks for reaching out to the Microsoft fabric community forum.</P> <P>&nbsp;</P> <P data-start="206" data-end="460">Could you please provide sample data that fully represents the issue or question you're referring to? Kindly ensure the data is in a usable format (e.g., Excel or CSV) rather than a screenshot, and does not contain any sensitive or unrelated information.</P> <P data-start="462" data-end="495">Looking forward to your response.</P> <P data-start="497" data-end="533"><STRONG>Best regards,</STRONG><BR data-start="510" data-end="513" /><STRONG data-start="513" data-end="533">Lakshmi Narayana</STRONG></P> Tue, 29 Jul 2025 07:30:27 GMT https://community.fabric.microsoft.com/t5/Developer/Percent-Difference-between-two-visuals-utilizing-slicers-and-two/m-p/4779509#M62388 v-lgarikapat 2025-07-29T07:30:27Z Re: Percent Difference between two visuals utilizing slicers and two different tables https://community.fabric.microsoft.com/t5/Developer/Percent-Difference-between-two-visuals-utilizing-slicers-and-two/m-p/4780128#M62402 <P>Hello Lakshmi</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Table 1 Slicers</TD></TR><TR><TD>Filter Month</TD><TD>Completed Year&nbsp;</TD><TD>Order Site</TD><TD>Class of Work</TD><TD>Distinct Count</TD></TR><TR><TD>1</TD><TD>2024</TD><TD>A</TD><TD>A</TD><TD>5</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>Table 2 Slicers</TD></TR><TR><TD>Filter Month</TD><TD>Completed Year&nbsp;</TD><TD>Order Site</TD><TD>Class of Work</TD><TD>Distinct Count</TD></TR><TR><TD>1</TD><TD>2025</TD><TD>A</TD><TD>A</TD><TD>3</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>What I like to return</TD></TR><TR><TD>Percent Differenct</TD><TD>&nbsp;</TD><TD>-40</TD></TR></TBODY></TABLE><P>Here is an example table - the table is duplicated so I can use slicers for each table to return the distinct count value like the example above</P><TABLE border="1"><TBODY><TR><TD>Order Name</TD><TD>Month Completed</TD><TD>Order Completed Year</TD><TD>Order Site</TD><TD>Class of Work</TD></TR><TR><TD>20NAR001</TD><TD>1</TD><TD>2024</TD><TD>A</TD><TD>A</TD></TR><TR><TD>20NAR001</TD><TD>1</TD><TD>2024</TD><TD>A</TD><TD>B</TD></TR><TR><TD>20NAR001</TD><TD>2</TD><TD>2024</TD><TD>A</TD><TD>C</TD></TR><TR><TD>20NAR002</TD><TD>1</TD><TD>2024</TD><TD>A</TD><TD>A</TD></TR><TR><TD>20NAR002</TD><TD>2</TD><TD>2024</TD><TD>A</TD><TD>B</TD></TR><TR><TD>20NAR002</TD><TD>1</TD><TD>2024</TD><TD>A</TD><TD>C</TD></TR><TR><TD>20NAR003</TD><TD>1</TD><TD>2024</TD><TD>A</TD><TD>A</TD></TR><TR><TD>20NAR003</TD><TD>1</TD><TD>2024</TD><TD>A</TD><TD>B</TD></TR><TR><TD>20NAR003</TD><TD>2</TD><TD>2024</TD><TD>A</TD><TD>C</TD></TR><TR><TD>20NAR004</TD><TD>2</TD><TD>2024</TD><TD>A</TD><TD>A</TD></TR><TR><TD>20NAR004</TD><TD>2</TD><TD>2024</TD><TD>A</TD><TD>B</TD></TR><TR><TD>20NAR004</TD><TD>2</TD><TD>2024</TD><TD>A</TD><TD>C</TD></TR><TR><TD>20NAR005</TD><TD>1</TD><TD>2024</TD><TD>A</TD><TD>A</TD></TR><TR><TD>20NAR005</TD><TD>1</TD><TD>2024</TD><TD>A</TD><TD>B</TD></TR><TR><TD>20NAR005</TD><TD>1</TD><TD>2024</TD><TD>A</TD><TD>C</TD></TR><TR><TD>20CMR001</TD><TD>2</TD><TD>2024</TD><TD>A</TD><TD>A</TD></TR><TR><TD>20CMR001</TD><TD>2</TD><TD>2024</TD><TD>A</TD><TD>B</TD></TR><TR><TD>20CMR001</TD><TD>1</TD><TD>2024</TD><TD>A</TD><TD>C</TD></TR><TR><TD>20CMR002</TD><TD>2</TD><TD>2024</TD><TD>A</TD><TD>A</TD></TR><TR><TD>20CMR002</TD><TD>1</TD><TD>2024</TD><TD>A</TD><TD>B</TD></TR><TR><TD>20CMR002</TD><TD>1</TD><TD>2024</TD><TD>A</TD><TD>C</TD></TR><TR><TD>20CMR003</TD><TD>1</TD><TD>2024</TD><TD>A</TD><TD>A</TD></TR><TR><TD>20CMR003</TD><TD>2</TD><TD>2024</TD><TD>A</TD><TD>B</TD></TR><TR><TD>20CMR003</TD><TD>2</TD><TD>2024</TD><TD>A</TD><TD>C</TD></TR><TR><TD>21NAR001</TD><TD>2</TD><TD>2025</TD><TD>A</TD><TD>A</TD></TR><TR><TD>21NAR001</TD><TD>1</TD><TD>2025</TD><TD>A</TD><TD>B</TD></TR><TR><TD>21NAR001</TD><TD>1</TD><TD>2025</TD><TD>A</TD><TD>C</TD></TR><TR><TD>21NAR002</TD><TD>2</TD><TD>2025</TD><TD>A</TD><TD>A</TD></TR><TR><TD>21NAR002</TD><TD>2</TD><TD>2025</TD><TD>A</TD><TD>B</TD></TR><TR><TD>21NAR002</TD><TD>2</TD><TD>2025</TD><TD>A</TD><TD>C</TD></TR><TR><TD>21NAR003</TD><TD>1</TD><TD>2025</TD><TD>A</TD><TD>A</TD></TR><TR><TD>21NAR003</TD><TD>1</TD><TD>2025</TD><TD>A</TD><TD>B</TD></TR><TR><TD>21NAR003</TD><TD>2</TD><TD>2025</TD><TD>A</TD><TD>C</TD></TR><TR><TD>21CMR001</TD><TD>1</TD><TD>2025</TD><TD>A</TD><TD>A</TD></TR><TR><TD>21CMR001</TD><TD>1</TD><TD>2025</TD><TD>A</TD><TD>B</TD></TR><TR><TD>21CMR001</TD><TD>2</TD><TD>2025</TD><TD>A</TD><TD>C</TD></TR><TR><TD>21CMR002</TD><TD>2</TD><TD>2025</TD><TD>A</TD><TD>A</TD></TR><TR><TD>21CMR002</TD><TD>1</TD><TD>2025</TD><TD>A</TD><TD>B</TD></TR><TR><TD>21CMR002</TD><TD>1</TD><TD>2025</TD><TD>A</TD><TD>C</TD></TR><TR><TD>21CMR003</TD><TD>1</TD><TD>2025</TD><TD>A</TD><TD>A</TD></TR><TR><TD>21CMR003</TD><TD>2</TD><TD>2025</TD><TD>A</TD><TD>B</TD></TR><TR><TD>21CMR003</TD><TD>2</TD><TD>2025</TD><TD>A</TD><TD>C</TD></TR><TR><TD>21CMR004</TD><TD>2</TD><TD>2025</TD><TD>A</TD><TD>A</TD></TR><TR><TD>21CMR004</TD><TD>2</TD><TD>2025</TD><TD>A</TD><TD>B</TD></TR><TR><TD>21CMR004</TD><TD>1</TD><TD>2025</TD><TD>A</TD><TD>C</TD></TR></TBODY></TABLE> Tue, 29 Jul 2025 15:12:38 GMT https://community.fabric.microsoft.com/t5/Developer/Percent-Difference-between-two-visuals-utilizing-slicers-and-two/m-p/4780128#M62402 JCATERINO 2025-07-29T15:12:38Z Re: Percent Difference between two visuals utilizing slicers and two different tables https://community.fabric.microsoft.com/t5/Developer/Percent-Difference-between-two-visuals-utilizing-slicers-and-two/m-p/4781182#M62415 <P>HIi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/1323500">@JCATERINO</a>&nbsp;,</P> <P data-start="180" data-end="248">Thank you for your prompt responses and for sharing the sample data.</P> <P data-start="250" data-end="452">I’ve implemented the required logic and uploaded the updated&nbsp; PBIX file for your review. Kindly take a moment to go through it and let me know if there’s anything that needs to be revised or improved.</P> <P data-start="454" data-end="487">Looking forward to your feedback.</P> <P data-start="454" data-end="487">&nbsp;</P> <P data-start="489" data-end="516"><STRONG>Best regards,</STRONG><BR data-start="502" data-end="505" /><STRONG>Lakshmi</STRONG></P> <P data-start="489" data-end="516">&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vlgarikapat_0-1753871868490.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1287236i127758077D7CC7BC/image-size/medium?v=v2&amp;px=400" role="button" title="vlgarikapat_0-1753871868490.png" alt="vlgarikapat_0-1753871868490.png" /></span></P> <P>&nbsp;</P> Wed, 30 Jul 2025 10:39:49 GMT https://community.fabric.microsoft.com/t5/Developer/Percent-Difference-between-two-visuals-utilizing-slicers-and-two/m-p/4781182#M62415 v-lgarikapat 2025-07-30T10:39:49Z