Forum Discussion
Filter based on Slicer selection
Hello, I am working on a financial report that must remove intercopmpany transactions. Intercomapny transactions are Identified as: Intercompany = IF('00-COA'[ACTNUMBR_5] = "9999" , "Yes","N...
Hi lcasey,
Slicer is used to filter responding rows. If you relate it to a report, the report will change according to the selected value in slicer. If there is no choice in slicer, it will display all values.
>>1. IF there are no filters applied at all then remove all Intercompany transactions
Intercompany transactions are stored in table as rows level? It it is, we are unable to remove all Intercompany transactions when there are no filters applied using sclicer.
2. IF "The Association" is selected in the ORG filter then show the transactions.
You can crate a slicer including all ORG values.
If this is not what you want, could you please share your .pbix file for further analysis?
Best Regards,
Angelia