cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Filling in blanks on a matrix

Good Day all,

 

I created a matrix that displays a count of incidents within a specific state and the time elapsed since their inception. I get some blanks within the matrix which I'd like to fill with zeroes. I'm not sure what the measure formalue should be. 

 

Please assist.

5 REPLIES 5
Highlighted
Solution Supplier
Solution Supplier

Re: Filling in blanks on a matrix

Hi

 

You can use replace values function when you import data into your model.

 

E.G. replace null with Zero

 

Power BI Help.JPG

Highlighted
Community Champion
Community Champion

Re: Filling in blanks on a matrix

I think i know what you are getting at.  When you place a field into the matrix, anytime your matrix does not have a value that relates to that row and that column, the matrix shows blank.

At first i was thinking "Oh this is easy, we'll fix it with a measure".  Nope, still shows blanks.

Ok, no worries, i'll use a date dimension table to make sure i have each date represented in my test matrix and that will force my measure to calculate for each!  Ok... that didn't work either.

I don't know what the solution is either.  It would be nice to have a toggle switch in the Visualisation options.

Highlighted
Microsoft
Microsoft

Re: Filling in blanks on a matrix

Hi @AbdulAzizAmod,

 

Could you try using the formula below to create a new measure to calculate the count of incidents, then show the measure on the Matrix to see if it works? Smiley Happy

count of incidents = COUNTA ( 'Your_Table_Name'[IncidentsColumn] ) + 0

 

Regards

Highlighted
Microsoft
Microsoft

Re: Filling in blanks on a matrix

Hi @AbdulAzizAmod,

 

Have you tried the solutions provided above? Do they work in your scenario? If they work, could you accept them as solution to close this thread?

 

If you still have any question on this issue, feel free to post here. Smiley Happy

 

Regards

Highlighted
Impactful Individual
Impactful Individual

Re: Filling in blanks on a matrix

if you create a measure could you set it to zero if it's blank?

 

I use the below formula to generate a zero value on an Esri ArcGIS map rather than a blank which messes the colouring of specific areas.

 

Total Call Number = if(ISBLANK(CALCULATE(sum(Fact_Glue_Data_Summary_Engineer_Data[Call Count Total]))),0,CALCULATE(sum(Fact_Glue_Data_Summary_Engineer_Data[Call Count Total])))

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors