Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic Slicer

I have a slicer called month year which is set to Aug 2018. so when i publish it to server, the default view of the page would be the visuals showing for Aug 2018. However, in Sept 2018, i would like...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

BobBI Hey i can use this. But as you can see in the following picture, I have set it to Sept 1- 30

 

 But the problem is when it moves to November, it will take Oct 1 - 31 in November. But this should become Oct 1 - 31 only on November 4th because that is when the data refreshes.  So if it changes to October 1 - 31 on November 1st my page will be blank.

BobBI's avatar
BobBI
Resolver III
7 years ago

Hi ,

Did you try approach1 ? if it doesn't work i will create a full working example and send it over to you.

Approach 1 :

 

Create a 'Current Month' column in your Date table ( if you don't have one , i would suggest to make a habit of using Date dim, very helpful).

Current Month =  if(
                                 Year('Date'[Date]) = Year(TODAY()) && MONTH('Date'[Date]) = MONTH(TODAY())

                                ,0

                               ,BLANK()
                               )

and  use this field as Visual level filter - Filter Type= Advanced Filtering

Show item when value = is

and enter 0 in the value ----apply filter.

use this as per your requirement at visual or page level.

 

Thanks,

Bob

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    BobBI It would be great if you can show the working! Thanks!