Skip to main content

Power BI

New

Customize text for "Blank value" in Card visual

Vote (2) Share
Ming Ye's profile image

Ming Ye on 07 Jul 2022 06:51:45

I implemented a section in Power BI report to track the invoicing status of vehicles that sold by dealers.

The table behind is just like:

VehicleID DealerID Status Other Columns

----------------------------------------------------------------------

1101 1 Stock Some value

1102 2 Invoiced Some value

1103 3 Delivered Some value

1104 2 Invoiced Some value

I added a Card visual that bound to count of VehicleID with filter 'Status = "Invoiced"'

When I select Dealer with 2 as DealerID from slicer, the Card display "2" as expected, but when I choose Dealer with ID "1" or "3", the card just display "(Blank)", which makes no sense to end users.


Surely we can replace the text with measure and some DAX tricks, but if we do so, we will lost drill through functionality (linked by VehicleID column).


If I may suggest, Microsoft could consider add feature that allow user to customize the text displayed for blank value.