How to display "No Record" in Matrix if there is no data for a column

[sivadoss87]

Hi All,

I have a data set like the below,

And  I am displaying this data by using Matrix visualization ,

For the categaory "E" there is no data for the month 2017-02 . So the value is Blank in the visual. I wanted to dispaly some text like "NR" in that place.

How could this be achieved, thanks in advance.

Regards,

P.Kalidoss

[Phil_Seamark · Accepted solution]

Hi @sivadoss87

I created a new Calculated table over your data as follows :

NR Table = 
        NATURALLEFTOUTERJOIN(
            CROSSJOIN(
                VALUES('Table1'[Category]),
                VALUES('Table1'[Yr-Mon])),
               'Table1')

And then on the new table I created the following Calcuated Measure

New Measure = if(sum('NR Table'[Value])=0,"NR",FORMAT(sum('NR Table'[Value]),"###"))

I could then create a matrix using the new table and measure

[sivadoss87]

Thanks a lot @Phil_Seamark

I will try this approach .

[v-huizhn-msft]

Hi @sivadoss87,

After test, @Phil_Seamark posted is right. If you have resolved your issue, please mark the reight reply as answer, which will help for other people. Thanks for understanding.

Best Regards,
Angelia