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.

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

Hello amitchandak 

 

And thank you for your quick answer. The problem presented in my initial message is a part of a "bigger picture". That's why I have tried to reproduce a smaller part that involving filtering the "Periods" table.

 

What I need is a "variable months back". I have already achieved it using the Periods table but showing the values as a matrix with  "variable number of columns" using a slicer with slider.

 

 

What I want to achieve is a "variable number of columns" based on the rows of the Periods table but not using the slider but a single selected value (in the same range 1-13).

 

With other words, after the user select a Year-Month I have to go back as many months user wants and I have it one way but I need another kind of selection.

 

Or if rephraze the question from my first message: How could I obtain the rows from the Periods table from 1 to 3 or from 1 to 10 or from 1 to whatever maximum value the user will select from a dropdown list?

 

I hope I get clearer now. 🙂

 

Kind Regards,

Lucian

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. 🙂