Forum Discussion
Edit Interactions doesnt work
dokat I understood the problem , while you stopped interaction with L4W,YTD etc the chart is not appearing the reason the chart values are coming from SELECTEDVALUE function based on the Slicer value.
So , if you stop interact with the slicer there is no Selectedvalue from the slicer and the Chart Muted!
Hi dokat
I am not user why u want to turn off intraction, because you are showing value in column based on SELECTEDVALUE of the slicer.
What ever, if you want to turn off intraction, you need to declare default value. Please find the two DAX below and change the default value as per your requirement (means if no slicer selected, what need to show) in blue line.
POS Dollar TY = VAR _slicer = SELECTEDVALUE('POS CY'[Slicer])
RETURN
SWITCH(
TRUE(),
_slicer="L52W",Calculate(SUM('POS'[Values]),'POS CY'[Slicer] IN {"L52W"},'POS'[Measures] IN {"Dollars"}),
_slicer="L4W",Calculate(SUM('POS'[Values]),'POS CY'[Slicer] IN {"L4W"},'POS'[Measures] IN {"Dollars"}),
_slicer="YTF",Calculate(SUM('POS'[Values]),'POS CY'[Slicer] IN {"YTD"},'POS'[Measures] IN {"Dollars"}),
SUM('POS'[Values]))
POS Unit TY = VAR _unit = SELECTEDVALUE('POS CY'[Slicer])
RETURN
SWITCH(
TRUE(),
_unit="L52W",Calculate(SUM('POS'[Values]),'POS CY'[Slicer] IN {"L52W"},'POS'[Measures] IN {"UNITS"}),
_unit="L4W",Calculate(SUM('POS'[Values]),'POS CY'[Slicer] IN {"L4W"},'POS'[Measures] IN {"UNITS"}),
_unit="YTF",Calculate(SUM('POS'[Values]),'POS CY'[Slicer] IN {"YTD"},'POS'[Measures] IN {"UNITS"}),
SUM('POS'[Values]))
If you have any question, please keep posted
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
