Forum Discussion

frostys's avatar
frostys
Icon for Helper I rankHelper I
8 years ago

Change a value by a variable in measure

Hi everyone,   I try change this value ("3") by a variable :       EOMONTH('Data input'[Date],3)>TODAY() I want to choose with a slicer the number of month. I have created a new table "Time sl...
Need Help
frostys's avatar
frostys
Icon for Helper I rankHelper I
8 years ago

Hi Ashish_Mathur,

 

The visualization is now working but with just the value "1".

When I select other values (ex:3,6,9,12)  in the slicer the visual keep "1" as month

Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
8 years ago

HI,

You can also try this, if both the above solutions doesn't satisfy you

 

Selected time = IF(ISFILTERED('Time slicer'[Time slicer]), SELECTEDVALUE('Time slicer'[Time slicer]), MIN('Time slicer'[time slicer]))

Here 

SELECTEDVALUE() with take values when some thing is selected in slicer. If nothing is selected, the MIN() (Minimum value) will be considered for the Column

 

Regards,

Thejeswar