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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
malikshiraz12
New Member

How to show interactive 4 week progress trend from report date in visual tab by using line and chart

Dear All,

 

I am trying to visualize the interactive 4-week progress trend from the report date in the visual tab by using a line and cluster column chart. but no success. The visual date axis looks static and doesn't change when changing the report date. 

 

Below visual showing four week trend (21-Oct to 11-Nov) fom report date 11-Nov-22 . and if i chnage the report date to 04-Nov-22 the trend should show the data from (14-Oct to 04-Nov). but its not.. trens is not sync with report date 

malikshiraz12_1-1668856875024.png

 

I have weekly data set for each contract (Example WO-43 & WO-50 showing plan and actual % on weekly basis ) and it looks similar to the below table.

malikshiraz12_0-1668856683690.png

 

i couldn't find any specific filter on this visual that will help showing the desire result.Therefore i am looking for expert advise  how to fix this issue. Not sure weather it is visual issue or modeling 

 

Kind Regards 

 

1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data in usable format, not as a screenshot.
Please show the expected outcome based on the sample data you provided.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.

Top Solution Authors