Forum Discussion

balu810's avatar
balu810
Icon for Advocate I rankAdvocate I
4 years ago
Solved

show all values in chart

i have a month filter which is filtering the chart with the respective selections , i have an requirments where i need to show all employees irrespective of selection in month and show 0 for them ,,i...
  • v-chenwuz-msft's avatar
    4 years ago

    Hi  balu810 , 

     

    You should create a new table only contains Year and Month, and use these columns to do filter.

    Date slicer = crossjoin(VALUES('Table'[Year]),VALUES('Table'[Month]))
    Use this expression to calcualte the Missing Time:

    Measure =
    VAR _c =
        CALCULATE (
            SUM ( 'Table'[Missing Time] ),
            FILTER (
                'Table',
                [Year]
                    IN VALUES ( 'Date slicer'[Year] )
                        && [Month] IN VALUES ( 'Date slicer'[Month] )
            )
        )
    RETURN
        IF ( ISBLANK ( _c ), 0, _c )
    

    Result:

     

    Pbix in the end you can refer.
    Best Regards

    Community Support Team _ chenwu zhu

     

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