Forum Discussion
Remove Filter to Calendar
- 4 years ago
Hi joshua1990
you can use
CALCULATE ( SUM (Sales[Sales]), CROSSFILTER (Sales[Sales Date], 'Calendar'[Date], NONE ))
Hi joshua1990 ,
Do you want the slicer to filter only on a specific column? According to your description, you want the month slicer to filter only budget, not sales.
Unfortunately, since the slicer is related to table visual, it is not possible to still show all rows when you have selected an item in slicer. Unless you disable the interaction between slicer and visual.
To workaround your requirement, you could create an unrelated table, as mentioned by Jihwan_Kim . You will get the result as shown below. The month slicer only filters budget, not sales.
However, if you want to get the result shown above without creating an unrelated table, there is no better way so far.
Best Regards