Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Johnsmith23
Frequent Visitor

Timeline slicer not interacting with visual properly

  • Facing issue in Displaying Proper data when a cell is chosen in timeline slicer
  • The Problem is it shows previous year data (Example If 2013 april is selected it shows 2012 april Data).
  • I have attached the images of fiscal year table and calendar table with some of the visual

Screenshot (302)-1.png

Screenshot (322)-1.png

Screenshot (324)-1.png

  

Screenshot (325)-1.png

Screenshot (326)-1.png

Screenshot (327)-1.png

  

4 REPLIES 4
collinq
Super User
Super User

HI @Johnsmith23 ,

 

Are you using a date dimension?  Also, what is the measure that you have for total income?




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Jelena_L
Frequent Visitor

Hi, have you add the slicer as measure?

 

@Jelena_L No.

  • I have dragged date column from fiscal year table and dropped  for slicer data
  • The granularity is only year quarter and month for the slicer.
  • In the visual I have added measure

Screenshot (334).png

Hi,

Share the download link of the PBI file.  Show the problem there clearly. 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.