Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi All,
Need an urgent help for my Power BI dashboard. In matrix visualization format, I have to show average billable hours against employees under various departments against every date ( cloumn). Now the challenge is if any employee who started working in middle of the month or just work for few days then only it show data/value only for that particular date in dasboard otherwise show blank. So is it possible to show zero instead of blank irrespectative of employee's data available or not. Please respond to my query at earliest. Thanks in advance.
Hi Amit,
Thanks for your prompt response. However I have some queries on your resolution , so could you please help to understand it in a better way by answering those below queries:
@sdas1 , Try measure like , summing current measure is m1
0 between range
Measure = var _1= [M1] +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))