Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
sdas1
Regular Visitor

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 ( 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.

sdas1_0-1686898141467.png

 

2 REPLIES 2
sdas1
Regular Visitor

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
  • sdas1_0-1686910233540.pngsdas1_1-1686910304768.png

     

  • 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:sdas1_2-1686910597094.png

     

amitchandak
Super User
Super User

@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))

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.