cancel
Showing results for 
Search instead for 
Did you mean: 
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
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.