Forum Discussion
Closing balance slicer problem
Hi Everyone
I want to show the closing balance per month and year from a table that looks like below:
| Site | Description | Date | Balance |
| A | Receivable A | 31-Jan-19 | 100 |
| A | Receivable A | 28-Feb-19 | 90 |
| A | Receivable B | 31-Jan-19 | 50 |
| A | Receivable B | 28-Feb-19 | 50 |
| B | Receivable A | 31-Jan-19 | 70 |
| B | Receivable A | 28-Feb-19 | 80 |
| B | Receivable B | 31-Jan-19 | 200 |
| B | Receivable B | 28-Feb-19 | 210 |
| C | Receivable A | 31-Jan-19 | 60 |
| C | Receivable A | 28-Feb-19 | 60 |
| C | Receivable B | 31-Jan-19 | 150 |
| C | Receivable B | 28-Feb-19 | 140 |
To calculate the closing balance I use this measure:
4 Replies
v-xicaiCommunity Support
Hi JaakLab
Based on my test, [Site] slicer not only works perfectly for Site A, but also for the Site B and C on the visual.
For example, when select Site B or C in slicer, return the result showing picture below.
You can check if there are other limitations on the visual showing the measure.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Ashish_Mathur
Super User
Thank you so much Amy and Ashish for the help. My error was that my 'Date' linked to my Calendar table and not to the date in the table containing the balances.
- Ashish_Mathur
You are welcome.
