Forum Discussion
Responsive ResidentBlank Values not shown in Matrix
Hi,
I have two tables connected together with a Many to Many relationship. Table A filters table B. The colums with Project ID's are connected to each other. A matrix shows working hours per project as per the hours informations in table B.
Most of the entries in table B are wihtout a project ID, so blank.
When I put the Project ID from Table A in the row of the matrix (which is connected to project ID from table B), the matrix shows the blank values (picture 1). Values are from Table B.
As soon as a put the the project Name (other column from Table A) in the row of the matrix, the entries with no project ID's are not shown anymore, but the total of the table remains the same. (picture 2)
Why are the blank entries not shown anymore in the second case?
Thanks in advance
Best regards
5 Replies
FarhanAhmedCommunity Champion
I don't see NULL values in screenshot #1. Can you please share it again, also some sample data .
But you check by clicking "Show Items with No Data" in visuals column list.
ITManuelThe first row with 446.996,23 as value has no ID in table B.
In picture one the row is shown, in the second picture not anymore.
Sorry I don't meant NULL values, but blank ID's.
- amitchandak
Super User
ITManuel , it may depend on the formula you used from both tables.
Share formulas. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- ITManuel
Hi amitchandak,
I'm afraid, the data set is quite big, don't really know how to make anonymous with little effort.
I tried to summarize the information in a pdf which you could download with link below.
Hope this provides ennough informations.
Thanks
- ITManuel
Hi amitchandak ,
sorry to bother you. Any chance to have a further look at it or are the provided informations not enough?
Thanks in advance
