Forum Discussion
DAX
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
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