cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
frostys Regular Visitor
Regular Visitor

Time Slicer

Hi !

 

I put a time slicer in a report :

 

Capture.PNG

 

The data come directly from a "date" column. 

 

I try to make an automatic selection for the current year and current month selected. (Exemple: if I select june 2018, it auto select january-may. If I select january 2019 it auto select january-december 2018).

 

Thank a lot !

 

4 REPLIES 4
ThomasFoster Established Member
Established Member

Re: Time Slicer

So the way I would do this is through changing the measure you are using for the visuals.

 

something like this should work, when a single month is selected it will calculate the specificd measure from the start of the calendar year to the previous month.

 

Measure =
IF (
    HASONEVALUE ( DateTable[Month] ),
    CALCULATE (
        [Measure],
        DATESBETWEEN (
            DateTable[Date],
            DATE ( YEAR ( MAX ( DateTable[Date] ) ), 1, 1 ),
            EOMONTH ( MAX ( DateTable[Date] ), -1 )
        )
    )
)

 

frostys Regular Visitor
Regular Visitor

Re: Time Slicer

I change some syntax who were not working, so this is the syntax who work

 

date2 = 

IF (
    HASONEVALUE ( 'Data input'[Date].[Month] );
    CALCULATE (
        
        DATESBETWEEN (
            'Data input'[Date].[Date];
            DATE ( YEAR ( MAX ( 'Data input'[Date].[Date] ) ); 1; 1 );
            EOMONTH ( MAX ( 'Data input'[Date].[Date] ); -1 )
        )
    )
)
        

Otherwise, is is not accept this measure as slicer

ThomasFoster Established Member
Established Member

Re: Time Slicer

So does the measure work for your needs?

 

The reason you had to make the changes are two fold

1. You are in a different region hence the , vs ;

2. You do not have a datetable linked to your data table hence having to use the inbuilt datetable.

 

Community Support Team
Community Support Team

Re: Time Slicer

HI @frostys,

 

Current power bi not support to create dynamic calculated column/table based on slicer/filter.

In addition, measure is possible to dynamic change based on slicer/filter, but power bi not support to use as source of slicer or axis of visual.

 

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |