Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

graph considering all weeks

Hello, I would like ask you about how I can get values when the date is not in my table, for example:   If I have a table with the follow info:   Date                  Score        Week 1/01/20...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    One way is to create a new calculated table for chart purpose

     

    From the Modelling Tab >>>New Table

     

    TableforChart =
GENERATESERIES ( MIN ( TableName[Week] ), MAX ( TableName[Week] ) )

     

    This will give you a single column table of week numbers including weeks that are missing in your table. Rename the Column to "week"

     

    Then create a relationship between yourtable and New Table.

    Then add a calculated column to it

     

    Score =
IF ( ISBLANK ( RELATED ( TableName[Score] ) ), 0, RELATED ( TableName[Score] ) )

    Now create a chart using this New Table

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Anonymous

 

One way is to create a new calculated table for chart purpose

 

From the Modelling Tab >>>New Table

 

TableforChart =
GENERATESERIES ( MIN ( TableName[Week] ), MAX ( TableName[Week] ) )

 

This will give you a single column table of week numbers including weeks that are missing in your table. Rename the Column to "week"

 

Then create a relationship between yourtable and New Table.

Then add a calculated column to it

 

Score =
IF ( ISBLANK ( RELATED ( TableName[Score] ) ), 0, RELATED ( TableName[Score] ) )

Now create a chart using this New Table