cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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

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

1 ACCEPTED SOLUTION
Microsoft Employee

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

Proud to be a Datanaut!

3 REPLIES 3
Microsoft Employee

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

Proud to be a Datanaut!

Frequent Visitor

Thanks a lot @Phil_Seamark

I will try this approach .

Microsoft Employee

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors