In Continuous week i want continuous line

[OmkarNag99]

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 

here is the forumla i used :- 

COUNT('Project-Tracker Main'[SOW Visibility Week ]) +0

[v-xinruzhu-msft]

Hi,

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

hello @OmkarNag99 , 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.

[OmkarNag99]

@v-xinruzhu-msft  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?

[v-xinruzhu-msft]

Hi @OmkarNag99 

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

[OmkarNag99]

Yes, @v-xinruzhu-msft  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.

[v-xinruzhu-msft · Accepted solution]

Hi @OmkarNag99 

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

[OmkarNag99]

@v-xinruzhu-msft  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?

[bhanu_gautam]

@OmkarNag99 , 

Use the IF function to check for blank values and replace them with 0.
Here is the DAX formula you can use:

SOW Visibility Count =
IF(
ISBLANK(COUNT('Project-Tracker Main'[SOW Visibility Week])),
0,
COUNT('Project-Tracker Main'[SOW Visibility Week])
)

Ensure Continuous Line: If you are using Power BI, make sure to use a line chart instead of a bar chart to get a continuous line. In the chart settings, ensure that the axis is set to show all weeks, even if some weeks have no data.

Configure the Chart: In Power BI, you can configure the chart to handle missing values by connecting data points with a line. This can usually be done in the chart settings under the "Format" pane.

[OmkarNag99]

Still not showing continuous week in power bi