Forum Discussion

Lucian's avatar
Lucian
Responsive 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
Responsive 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