Forum Discussion

cham's avatar
cham
Post Patron
7 years ago
Solved

Slicer

Hi,   Once I select the date in slicer, I need to change the data in the table and pie chart which are not equal to that selected date and also I need to avoid the data from future dates.   When ...
  • Thim's avatar
    Thim
    7 years ago

    So i can not find a "Smart" way to do this.

    Maybe someone who understands M coding can, or there is a smart trick some where.

     

    But here is a way you can do it.

     

    You will need two filters, one for the date, and one for the date in an ascending index.

     

    First use to RANKX

    Here is my formula

    Index = RANKX(
    ALL(Table);
    RANKX(ALL(Table);Table[Last Contact];;ASC)
    )
    This will make sure the latest date, has the lowest number.
     
    First filter date as everything before. (In my case everything before 15-10-2015).
    Then select everything and the remove the lowest number on the index. (This will remove the current day.)
     
    As you can see i have all dates chosen from the first filter except the 15-10-2017, as this was index 17.


    Hope this will help, but yea. not a nice looking way to do it.
     
Thim's avatar
Thim
Resolver V
7 years ago

So i can not find a "Smart" way to do this.

Maybe someone who understands M coding can, or there is a smart trick some where.

 

But here is a way you can do it.

 

You will need two filters, one for the date, and one for the date in an ascending index.

 

First use to RANKX

Here is my formula

Index = RANKX(
ALL(Table);
RANKX(ALL(Table);Table[Last Contact];;ASC)
)
This will make sure the latest date, has the lowest number.
 
First filter date as everything before. (In my case everything before 15-10-2015).
Then select everything and the remove the lowest number on the index. (This will remove the current day.)
 
As you can see i have all dates chosen from the first filter except the 15-10-2017, as this was index 17.


Hope this will help, but yea. not a nice looking way to do it.
 
  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi Thim

    Have you tried to modify the code that is generating the data for your chart as in:

     

    CALCULATE (
    [Measure/code generating data for your chart];
    FILTER (
        ALL ( TableName[Last contact] );
        TableName[Last contact] <= MAX ( TableName[Last contact] )
    )
)

     

  • cham's avatar
    cham
    Post Patron
    7 years ago

    Thank you Thim. This is helful