Forum Discussion
balu810
Advocate I
4 years agoshow 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...
- 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 RegardsCommunity 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.
amitchandak
Super User
4 years ago