Forum Discussion
Removing (Blank) from a card visual
Hi,
I’m in the process of creating a helpdesk ticket analysis report. I have Card Visuals showing metrics like total tickets, open tickets, closed tickets, etc. However, I’m encountering an issue with the Card Visual displaying (Blank) instead of 0 when there are no matching rows.
I understand that this can be fixed using DAX measures (e.g., with COALESCE() to replace blanks with 0). However, I also have drill-through enabled on these Card Visuals, allowing users to right-click and drill-through to a more detailed table on another page (filtered by ticket_number). As far as I understand, drill-through functionality on Card Visuals doesn’t work with measures. It requires using a field like ticket_number and setting an aggregation (e.g., Count). When I replace the field with a measure to handle blanks, the drill-through option disappears from the right-click menu.
I've tried Transform>Replace Values then replacing null with 0 replace but that doesn't seem to be working.
Are there any recommended work arounds for this scenario? Any insights or suggestions would be greatly appreciated! Thanks
I tested it with simple data and it seems to work well.
Use the measures similar to the following so that your measures displays 0 when you return to BLANK().
NewOpenTickets = IF(ISBLANK([OpenTickets]), 0, [OpenTickets])Place this measure in the card visual and replace the original measure with this measure as a drilldown field in the drilldown target page.
If you are still having problems with drillthrough, please provide sample data that replicates your problem, and it would be nice if you could share the pbix file (remove privacy information).
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- bhanu_gautam
Super User
patrickbrooks13 First, create a calculated column that will handle the null values and replace them with 0. This will ensure that the drill-through functionality remains intact since it relies on fields rather than measures.
TicketCount = IF(ISBLANK([ticket_number]), 0, [ticket_number])
Replace the field in your Card Visual with the new calculated column. This will display 0 instead of (Blank) when there are no matching rows.
I've tried this but it doesn't work unfortunately. It's my understanding that it would just sort blank values in the ticket_number column, my issue is that there are no rows in the dataset after applying filters. So the card visual using ticket_number count displays (Blank)
I tested it with simple data and it seems to work well.
Use the measures similar to the following so that your measures displays 0 when you return to BLANK().
NewOpenTickets = IF(ISBLANK([OpenTickets]), 0, [OpenTickets])Place this measure in the card visual and replace the original measure with this measure as a drilldown field in the drilldown target page.
If you are still having problems with drillthrough, please provide sample data that replicates your problem, and it would be nice if you could share the pbix file (remove privacy information).
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
