Forum Discussion

sdas1's avatar
sdas1
Frequent Visitor
3 years ago

Replace blank with zero value in Matrix visual when data not available

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 ( cloum...
Need Help
sdas1's avatar
sdas1
Frequent Visitor
3 years ago

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:

  • Are you advicing to create a  separate table by using "CALENDAR" function and then create a relationship between Calendar table and " Start Date" from the main table " Planned time Utilisation" . Refer the below screenshot for your reference

  •  

  • 0 between range
    Measure = var _1= [M1] +0 what does that mean?  What does M1 here means. You also mentioned current measure. So are you referring below meausre as higlighted in below screenshot: