Forum Discussion

pratk30's avatar
pratk30
Icon for Advocate I rankAdvocate I
9 years ago

Draw a X-axis based on three date column in Line Chart

Hi Team,   I have a requirement where i need to draw a Line Chart, for e.g I have two tables - one is Session Table to record each session start and end date. 2nd is Student table to record regist...
Need Help
P3Tom's avatar
P3Tom
Icon for Helper I rankHelper I
9 years ago

Hi pratk30,

 

What is wrong (what don't you like) with your current approach? 

 

I think there are issues with model design and measures:

 

You can improve the model design by:

 

Separate facts (data) from dimensions (lookups) into different tables.

 

Clarify you data: Are start and end dates against the Session or against the Student or against the Registration (I have a guess, but I should not ever use a guess)?

 

Also, what are the the business questions you are trying to answer with your chart (this will determine the type of measure to write)?

 

Tom

www.powerpivotpro.com

pratk30's avatar
pratk30
Icon for Advocate I rankAdvocate I
9 years ago

Hi Tom,

 

Thanks for response.

I have updated my question, would give a clear scenerio.

 

I have to show a data on line chart where based on date column and this date value shoud be fall between start and end date which is coming from another table. And this start and end date should be visible on X-axis.