cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LMorman
Helper I
Helper I

how to display a null value

I am trying to create a table or matrix to represent call coverage by a Sales person.  I need to display all companies assigned to a sales person and the date they last contacted them.  The table needs to also display the client name even if there has not been any recent contact. 

1 ACCEPTED SOLUTION
ankitpatira
Community Champion
Community Champion

@LMorman If I understood your question correctly you want to display blank space in a table visual if sales person doesn't have a company name (not contacted). If you're using table visual you can click on a dropdown of a field and click 'Don't summarize'. This will show you all the values including nulls.

View solution in original post

5 REPLIES 5
v-haibl-msft
Microsoft
Microsoft

@LMorman

 

Please try the solutions provided by ankitpatira and philipplenz to see if it works.

I tried with following simple table and it seems that the null value can be displayed properly. Please post back what’s your table like if you still have the problem.

 

how to display a null value_1.jpg

 

Best Regards,

Herbert

LMorman
Helper I
Helper I

I am trying to create a table or matrix to represent call coverage by a Sales person.  I need to display all companies assigned to a sales person and the date they last contacted them.  The table needs to also display the client name even if there has not been any recent contact. 

Anonymous
Not applicable

Do you mean a table like this?

Account | Amount

A            | 100

B            | NULL

C            | 200

 

When you put the column Account in a axis and summarize the amount, the Account B is hidden. To display this account, click in the Axis on account (when you use a graph) on the drop down field, and select "display elemns without data". If you use a table, you must select the field in the rows.

ankitpatira
Community Champion
Community Champion

@LMorman If I understood your question correctly you want to display blank space in a table visual if sales person doesn't have a company name (not contacted). If you're using table visual you can click on a dropdown of a field and click 'Don't summarize'. This will show you all the values including nulls.

Anonymous
Not applicable

Worked perfectly for me, thanks!

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!