Power BI - Categories with no data

Hello, friends and welcome to Tutorials Point

In this segment of the video, we are going to see how to view categories with no data

Now by default in Power BI desktop, what happens is whenever I have a column heading

it will only be shown in the report page if it has certain data into it

Now let's take for an example, I have a car sales table, right

In this table, I have few of the categories which has not generated any amount of sales

So whenever you try to create a report for the same in a table or in a matrix visualization

it will not display those category which has no data into it

Now in order to see that, what we have to do is we have to go under the visualization

pane and under the visualization pane you will find that particular field

If you click on that drop-down menu, you will find an option which says, show items with

no data. The moment you click on it, it will show you those items as well

which has no data in it. Now let's go ahead and see it practically how it is done

Hello friends and welcome back. In this part of the video I'm going to show you how to

view categories with no data into it. Alright so let's get started off. I will move on

to the field paints and out here I have created a new table with say car sales. If I open

this table I have two columns which have the car names into it and their relative

sales along with it. So I will quickly take it take these two columns and create a table chart so I will take here sales and I take this cars so I have name of all the cars and their respective sales along with it let get it in a tabular format so I have to select this table in which I can see the name of all the cars and their respective sales along with it and at the bottom

I can see the total as well let's quickly go ahead and increase the font size

so that everybody can see this particular report okay I will also go ahead and

increase the column header size from here and I'll increase it all right

So now you must be thinking that I must be having all the entries

But no, that is not the scenario. Power BI tend to take only those entries which has some record into it

If there is a blank entry, it tends to skip it. Now how will I figure that out

I simply have to go under this field pane and under this field pane, I will go under this

CAST drop-down menu. The moment I click on this drop-down menu out here, the very second last option which I see is

is show items with no data. That means there have been some certain cars which

there has been no sales. So if I want to see those as well I simply click on this

option. The moment I click on this option I see there are two more entries which do not

have any sales associated with it and that is the reason PowerBi was not showing

them on your table screen. So guys this is how simple it is if I want to view any

hidden data or any data with no data in any category with no data

into it you simply have to go under this field pins and select that column and click on the drop-down menu and select this particular option which says show item with no data all right guys so this was all for this video see you until next time