Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Matrix full of measures - when formatting blank rows show up!

Hi everyone,

I have generated a matrix full of measures a bit like this 



and the result is brilliant, showing something like this:


However, i'm trying to format the values (e.g. Area to 1 decimal place, Tonnes rounded to nearest number etc)

 and so i attempted a format function:


and suddenly all these blank rows show up with no data (but is all the available dates in my date table which is one of the columns)


Does anyone know (1) is there another way to format my numbers in the matrix full of measures and / or why the table suddenly show so many empty rows?


Super User IV
Super User IV

@ssze , Difficult to tell without looking at data.


The formatting it changing it into text. That might have cause this issue. There was the solution proposed by Guyinacube using external tools. See if that can help


measure slicer

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!


thanks @amitchandak , i had a look at the youtube and it looks good (although i'm still struggling to wrap my head around it a bit, as the values are not showing as i want).

i tidied up my example and hope this works for a download:


the top table has all the data i want,



but i want to format it to the table below (i have compiled all the measures into a matrix)so i can have 2 layer headers



however, i want to be able to format the columns differently 

e.g. area to 1 decimal place, 

volume tonnes to nearest digit, but t/ha to 1 decimal place, sales to $ etc etc.


Would really appreciate any feed back. Been going through google searches for ages now and can't come up with much more!



Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors