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

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

Anonymous , 

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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Still not showing continuous week in power bi