Forum Discussion
Total balance for previous
Hi hafchez ,
If the “previous” means the first selections, you could create two slicers and use “Interaction” feature to control different filters, like:
Or if it isn't your expected output, please describe your questions in more detail to help us clarify your scenario.
Refer to
Change how visuals interact in a report - Power BI | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
The data need to shows 2 different result. One for the filtered amount (which as per example, we need the result shown in the table) and another result for the total previous amount. For example, if I filtered user ID 1 for the selective date from Jan 2022 - Mar 2022, the table result will shows the transaction amount for Jan 2022 - Mar 2022 and for the card visual will shows automatic (maybe with DAX) the total amount for all previous data we have (if we have data from 2020, we need the total balanced calculated for all data from Jan 2020 - Dec 2021). The slicer are only for User ID and Date. Hope there is solution for this as I have tried many solutions from the community but theres always error because we have multiple data with same date.