Forum Discussion
How to include data that is not in the dataset?
Hi,
On the format pane under Rows where you have the column ServiceType, click on the ▼ to the right, before the X.
Then on the menu choose: Show items with no data:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data
Br
Marius
But that would work if I have 2 tables and a relation, right? One table with the categories and the other whith the deliveries.
The problem is that I was given this dashboard with one large dataset that comes from 1 SQL Statement.
Should I then create a table with the categories and try to link these 2 tables?
mariussve1Solution Sage
Yes, that is correct. To recognise the items with no values this needs to be a dimension connected to the fact table. Or else the values will be filtered out.
So Please create a dimension containing distinct values and connect it and then it will work.
Marius
SO, I created the dimention likr this:
I created the relation as well
ANd now is shoing the rows. Is there a way to replace blank spaces with 0?