Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

In Continuous week i want continuous line

Hi Team, Here i'm attached a one snip shot  Basically i want continuous line in Bar chart but it is not showing in the chart. in same chart which places are shows blank should replace with 0...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous 

    You can refer to the following.

     

    Create a new table

    Table2 =
SUMMARIZE (
    ADDCOLUMNS (
        CALENDAR ( DATE ( 2022, 1, 1 ), DATE ( 2024, 12, 31 ) ),
        "Year-WeekNum",
            WEEKNUM ( [Date] ) & "`"
                & RIGHT ( YEAR ( [Date] ), 2 )
    ),
    [Year-WeekNum]
)

    Then create a 1:n relationship between the tables.

     

    Then create the the measures .

    Plan Line = SUM('Table'[Cum_visible])+0
    Real Line = SUM('Table'[Cum_visible_Completed])+0

    Then put the following field to the visual.

     

    Output

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi,

Thanks for the solution bhanu_gautam  offered, and i want to offer some more information for user to refer to.

hello Anonymous , based on your descriotion, you can create a new table to store the week , you can refer to the following sample.

Sample data

Create a new table week

 

Create a 1:n relationship between tables.

 

Then create the measure.

Measure = SUM('Table'[Value])+0

Put the measure and the week field in week table to a visual.

 

Output

 

It is continuous.

 

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Anonymous  thanks for the solution🙂 ...

I am facing an issue with my dataset. The dataset spans three years and contains data for multiple weeks. I'm unable to establish a proper many-to-one (1:*) relationship because of this structure.

When I remove duplicate weeks or use data from only one year, I get the expected output. However, this doesn't fulfill my requirement, as I need to analyze the data across the full three-year period.

Could you please help me find a solution to this issue?

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous 

    Thank you for your reply, and based on your description, can you provide some sample data so that can provide more suggestion for you.

     

    Best Regards!

    Yolo Zhu

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

       

      Yes, Anonymous  I'm sharing the sample & short data based on my chart.

      In my chart:

      X-axis: Concatenation of YEAR and WEEK.
      Y-axis: 2nd column is Count of Visible.
      Plan Line (Y-axis): 3rd column is Cumulative count of Count of Visible.
      Actual Line (Y-axis): 4th column is Cumulative count of Count of Visible where the Status is Completed.
      Legend: Represents different types of SOW.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi Anonymous 

        You can refer to the following.

         

        Create a new table

        Table2 =
SUMMARIZE (
    ADDCOLUMNS (
        CALENDAR ( DATE ( 2022, 1, 1 ), DATE ( 2024, 12, 31 ) ),
        "Year-WeekNum",
            WEEKNUM ( [Date] ) & "`"
                & RIGHT ( YEAR ( [Date] ), 2 )
    ),
    [Year-WeekNum]
)

        Then create a 1:n relationship between the tables.

         

        Then create the the measures .

        Plan Line = SUM('Table'[Cum_visible])+0
        Real Line = SUM('Table'[Cum_visible_Completed])+0

        Then put the following field to the visual.

         

        Output

         

        Best Regards!

        Yolo Zhu

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly