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...
Need Help
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