Forum Discussion
How to avoid blank codes/values being removed
Hi all, I hope everyone is well! I am creating a new Dashboard but I'm having some issues I'm hoping someone might have an answer to 🙂 I have two main tables, a PostedSalesShipmentHeader...
Anonymous hello,
the way power bi "hide" the row is that there is blank value for the measure you use. If you wanna brute force it, you can set your field by right clicking and click "Show data with no values" (or something like that.
Alternatively, you can modify measure that would calculate something for the blank values as well. (be careful with these, this can go quickly sidewise, as it will assign value to everything in your table).
Hi Anonymous
Use the below dax:
DisplayedAddress =
IF(
ISBLANK(SELECTEDVALUE(PostedSalesShipmentHeader[Ship-to Code])),
BLANK(),
MAX(ShipToAddress[Address])
)