Forum Discussion

JCATERINO's avatar
JCATERINO
New Member
1 year ago
Solved

Percent Difference between two visuals utilizing slicers and two different tables

Can someone please help:

1. I created two tables that are filtered by several slicers - Month, Year, Site and Class of Work

2. Both cards display the distinct count of Orders completed based on the slicers

3. I would like to create a visual card that calculated the percent difference between the two cards

 

Example

First Card returns 352 orders for 2025, Site A, Class of Work A

Second Card returns 645 orders for 2024, Site A, Class of Work A

 

I would like to calculate the percent difference based on the slicers so it would filter dynamically.

Need Help

3 Replies

  • v-lgarikapat's avatar
    v-lgarikapat
    Community Support
    1 year ago

    Hi JCATERINO ,

    Thanks for reaching out to the Microsoft fabric community forum.

     

    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.

    Looking forward to your response.

    Best regards,
    Lakshmi Narayana

    • JCATERINO's avatar
      JCATERINO
      New Member
      1 year ago

      Hello Lakshmi

       

      Table 1 Slicers
      Filter MonthCompleted Year Order SiteClass of WorkDistinct Count
      12024AA5

       

      Table 2 Slicers
      Filter MonthCompleted Year Order SiteClass of WorkDistinct Count
      12025AA3

       

      What I like to return
      Percent Differenct -40

      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

      Order NameMonth CompletedOrder Completed YearOrder SiteClass of Work
      20NAR00112024AA
      20NAR00112024AB
      20NAR00122024AC
      20NAR00212024AA
      20NAR00222024AB
      20NAR00212024AC
      20NAR00312024AA
      20NAR00312024AB
      20NAR00322024AC
      20NAR00422024AA
      20NAR00422024AB
      20NAR00422024AC
      20NAR00512024AA
      20NAR00512024AB
      20NAR00512024AC
      20CMR00122024AA
      20CMR00122024AB
      20CMR00112024AC
      20CMR00222024AA
      20CMR00212024AB
      20CMR00212024AC
      20CMR00312024AA
      20CMR00322024AB
      20CMR00322024AC
      21NAR00122025AA
      21NAR00112025AB
      21NAR00112025AC
      21NAR00222025AA
      21NAR00222025AB
      21NAR00222025AC
      21NAR00312025AA
      21NAR00312025AB
      21NAR00322025AC
      21CMR00112025AA
      21CMR00112025AB
      21CMR00122025AC
      21CMR00222025AA
      21CMR00212025AB
      21CMR00212025AC
      21CMR00312025AA
      21CMR00322025AB
      21CMR00322025AC
      21CMR00422025AA
      21CMR00422025AB
      21CMR00412025AC