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

Timeline Slicer and measurement Calculate

Initialy I have a measurement to calculate our sales

Total = CALCULATE(sum(SalesOrderSummaryGI[Amount]),FILTER(ALL(SalesOrderSummaryGI[Date]),SalesOrderSummaryGI[Date]<=MAX(SalesOrderSummaryGI[Date])))

And it perfectly works like thisslide 1.PNG

 

 

 

 

 

 

 

 

 

 

 

 

Then I tried to use Timeline visualization and after that picture changed to that

 

slide 2.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

How can I fix it and return to the previous picture?

1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft
Microsoft

@Alexakdr

 

I haven't reproduced your issue. 

 

4.PNG

 

Did you apply any filter after you put the TimeLine slicer? Can you share your .pbix?

 

Regards,

View solution in original post

2 REPLIES 2
v-sihou-msft
Microsoft
Microsoft

@Alexakdr

 

I haven't reproduced your issue. 

 

4.PNG

 

Did you apply any filter after you put the TimeLine slicer? Can you share your .pbix?

 

Regards,

View solution in original post

Yes you are right! I moved filters from the vizualization level to data column and now it works

Thank you!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors