Forum Discussion
Solved
How to include data that is not in the dataset?
Hello all, I have to present a table/matrix in a dashboard that includes the amount and a percentage of that amount from the total of deliveries separated by Delivery Type. Our company only d...
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
mariussve1
Solution Sage
Solution SageYes, 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?