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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Try this

 

Selected time = MIN('Time slicer'[Time slicer])

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    That is due to something else then.  Share the link from where i can download your file.  Expain the business problem and show the expected result.

  • 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