Hi,
I looked around on the internet for a couple of hours but can't find a solution.
I have got some tables wich is my information. The lookup tables. This is information about projectnumbers and names. Quotation / offer numbers and names. And billingnumbers and names. So, on a project, a supplier can get an assignment to deliver something wich is set into the system as a quotation number. Later, the supplier will send the first bill, second bill, etc for that number.
I have 2 tables wich is the data. One has the Quotation infomation. One has the billing information.
Sometimes, for one project, there is no bill yet, but an assignment is given, so there is a quotation number.
When I put this data in a Matrix table in Power BI Desktop. And you zoom in on the project number, you see the quotation numbers. (I have the data for this in one column A) If I zoom in on the quotation number, you see the bills that are send. (this is in another column B).
But........
If there is no bill yet. The row with the Quotation number magically dissapears in the matrix table. So it only goes on level lower if there is a bill. Solution is to zoomout again with the arrow up at the rightuppercorner of the matrix. Or maybe reset the table a bit untill you see the proper data again.
For me, this is understandable. But for my users, they have no clue what is happening. Don't know about the options to zoom out and reset the table. Just continue but have incomplete information about there projects.
Is there any way to just show empty rows if there is no bill? Or to put a warning that you cant zoom any further at this particular quotation? Or to just leave it as it is but not remove the row?
Thanks in Advance
