Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Missing supplier invoices

Dear Community Members,

My Name is Sayed and working as an Account Payable for a Pharma Industry. I am completey new with Power BI.

I receive invoices from our suppliers every month. I have generated a Dashboard where I can see how much did I pay for each supplier for a specific period.

what is the best practice to generate a Filter where I see, which invoices I did not received for the selected period.

Can anyone please help?

 

Kind Regards,

Sayed 

Need Help
Tips and Tricks

3 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Icon for Super User rankSuper User
    2 years ago

    Hello Anonymous ,

     

    you need to have a column in your table that will have the status of the invoice of its received or its not then use this column in a slicer to filter bi received or not.

     

    so let's say this is the invoices (just for a demo) with the column status

     

    then you have them in a table and the status in the slicer like the following

    when you click on the pending, it will show the ones that are still not received

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hello Idrissshatila, 

    Thank you for the provided solution.

    Let's explain my question another way around.

    I don't wanna put anything manually.

    I set a date Range (ex. 05.2023 - 04.2023).

    My Visual should look for Vendor based on given date and give me below Information.

    I wanna get two Reports.

    1. A list of Supplier with invoice amounts per month.

    2. A list of Supplier with missing amounts per month. -> based on given date.

     

    I am sure there is a way to get to such information. Since I am new with Power BI, I just have to search and search and search.

     

    Regards,

    Sayed