Forum Discussion
Show Items with No Data
Hi,
Looking for some assistance/guidance, when using Power BI I have created a matrix which has the following rows:
User
Category
Description
Sum of QTY
My dataset could look like this:
| User | Category | Description |
| test1 | Computers | Computer 1 |
| test2 | Computers | Computer A |
| test2 | Mobile | Mobile A |
| test3 | Accessories | Wireless Mouse |
| test3 | Computers | Computer B |
I can see each user fine, however I tried to "Show Items with No Data" on Category - this would mean when I expand any user test1,test2 or test3 I would see category "Mobile", "Computers" and "Accessories" against each user even though they don't have anything against them. (e.g. test1 and test 3 have no data in Mobile Category and test 2 and test 1 have no data in Accessories Category)
I tried to make a table using DISTANCT and VALUES however when i add relationship in it doesnt seem to affect it?
Thanks,
adam_b , Not clear. Add +0 to you measure and try
1 Reply
adam_b , Not clear. Add +0 to you measure and try