Forum Discussion

nothingman's avatar
nothingman
Regular Visitor
8 years ago

Get slicer value after disabling interactions

I have a bar chart and date slicer and I disabled interaction between those two. However I would like to have possibility to reference the actual value in a slicer in a measure used with the bar char...
Need Help
Tips and Tricks
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi nothingman

 

I think

SELECTEDVALUE (SlicerTable[SlicerColumn])

 

should work if you select only one value in the slicer.

nothingman's avatar
nothingman
Regular Visitor
8 years ago

The function that you've proposed doesn't work because the interaction between slicer and bar chart is turned off so SELECTEDVALUE sees all values in the date column. This is my main issue - how to get a reference to value selected on a slicer even though the interaction is turned off

  • ricardocamargos's avatar
    ricardocamargos
    Continued Contributor
    8 years ago

    Hi nothingman,

     

    You can use:

     

    If you are using the "between" option:

    First selected value = CALCULATE(FIRSTDATE(DIM_DATA_2[Date]); ALLSELECTED())

    Last selected value = CALCULATE(LASTDATE(DIM_DATA_2[Date]); ALLSELECTED())

     

    If you are using the "list" option you can do like Zubair_Muhammad said:

    SELECTEDVALUE(DIM_DATA_2[Date]).

     

     

    Ricardo

  • PowerBI129's avatar
    PowerBI129
    Regular Visitor
    6 years ago

    Hello,

     

    Were you able to fix this problem ? I am facing the same issue now and still can't fix it!

     

    Thank you!