Forum Discussion

Lucian's avatar
Lucian
Icon for Responsive Resident rankResponsive Resident
6 years ago
Solved

Return an interval starting from single selection

Hello, It might sound like a stupid question but in this very moment I cannot "see" how could I solve it nor find an "enlighting" article, so I have to ask you.    I need to calculate a measure so...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , Lucian 

    Create a seperated table to replace the field "Order" in the slicer:

     

    slicer_table = DISTINCT(Periods[Order])

     

    Then apply the following measure to filter pane.

     

    Slicer  control = 
var order1=SELECTEDVALUE(Periods[Order])
var order2=SELECTEDVALUE(slicer_table[Order])
return IF(order1<=order2,1,0)

     

     

    pbix attached

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi , Lucian 

Create a seperated table to replace the field "Order" in the slicer:

 

slicer_table = DISTINCT(Periods[Order])

 

Then apply the following measure to filter pane.

 

Slicer  control = 
var order1=SELECTEDVALUE(Periods[Order])
var order2=SELECTEDVALUE(slicer_table[Order])
return IF(order1<=order2,1,0)

 

 

pbix attached

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Lucian's avatar
Lucian
Icon for Responsive Resident rankResponsive Resident
6 years ago

Hi v-easonf-msft 

 

Indeed your answer did the trick, and also the topic recommended by amitchandak was inspiring, because both of you reminded me (and I quote from the Inception movie):

 

"a truth that she once knew...but chose to forget"

 

In my case the "disconnected table" were the words "I choose to forget"... 😁

My mistake was using the Order column from the "Periods" table for the slicer.

 

So thank you both for reminding me. 🙂