Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power Bi Matrix or Table dont show 0 Value

Dear All,

I have in my model sales (Pack qty) and (Target) for diffrent types of sector (AM and PM) Check the attached screenshot and compare between the first part and second part in the screenshot.

 

first part i have 2 lines AM and PM with values and they appear normally

second part , the AM has no pack qty (as seen in the table, there is no sales) accordingly the whole line didnt appear, I need to make the line appear because since the packqty is 0 the Target alos disappeared and not counted

 

 

Need Help

1 Reply

  • audreygerred's avatar
    audreygerred
    Icon for Super User rankSuper User
    2 years ago

    In the Build a visual pane, try to right click on your field for Sector and select 'Show Items with no data'. It is weird that the line is disappearing even though it has Target information. I would expect AM to stay, but be blank for Pack Type and have a value for Target.

     

    Also, I would suggect making measures for Pack Qty and Target:

    PackQty = SUM('Table'[PackQty])

    TargetPacks = SUM('Table'[TargetPacks])