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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors