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...
Need Help
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])