Forum Discussion
DAX
I HAVE A TABLE WHICH HAVE DIFFERENT MEASURES AND I WANT TO APPLY A MONTH FILTER TO A SINGLE COLUMN NAME "LYSM". ALL OTHER MEASURES WILL BE AFFECTED IF I CHANGE ANY MONTH VALUE.
Hi Anonymous ,
Base on your description, all of measures values are changed dynamically base on the month slicer option. However, you want only LYSM values changed with month slicer option, other measures values not changed.... You can follow the steps to get it:
1. "Separate" the visual into two visuals(one visual include LYSM--visual1, other visual include the other measures--visual2)
2. Change the interaction of visual2: select the month slicer and click visual2 choose no impact icon
Change the interaction behavior
Best Regards
3 Replies
Hi Anonymous
I am not sure I understood correctly.
In the table, there is a column LYSM, is it a measure or a column?
When you apply a month slicer, what is the behavior you are expecting for LYSM column?
What is the behavior you expecting for the other column except LYSM column?
What is the issue you are facing?basically its a table which have different measures as columns and from different sources. LYSM is (last year same month) sale values of last year same month. And its showing sales of whole last year and i need to add a month filter to it. but i dont want to affect other measures but commonly adding a month slicer ..... so is it possible to add a month filter just to that one measure without affecting the table
Hi Anonymous ,
Base on your description, all of measures values are changed dynamically base on the month slicer option. However, you want only LYSM values changed with month slicer option, other measures values not changed.... You can follow the steps to get it:
1. "Separate" the visual into two visuals(one visual include LYSM--visual1, other visual include the other measures--visual2)
2. Change the interaction of visual2: select the month slicer and click visual2 choose no impact icon
Change the interaction behavior
Best Regards
