Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a report parameter that is populated by a query; however, at the source, it is optional and thus returns an amount of nulls. When allowing multiple values to be selected, the nulls disappear. Why Paginated Reports doesn't allow this is another question, SO I would like to convert nulls to "(Blank)" in my query to get around this but need help with the DAX syntax. Is this possible? The code is
EVALUATE SUMMARIZECOLUMNS('Projects'[SubDomain], FILTER(VALUES('Projects'[ProjectStatus]), ('Projects'[ProjectStatus] = "Active")), FILTER(VALUES('Projects'[WorkType]), ('Projects'[WorkType] = "Project")))
ORDER BY ('Projects'[SubDomain])
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 8 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |