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!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hi All,
I have a matrix visualisation which has data like this:
It's a tracker to track who've filled in the feedback form for that particular week.
1 means it is filled while blanks mean they've missed ( No entry is there for that week in my raw data). I just wanna know if it's possible to get blanks to appear as 0 or Text like "Feedback form missed" and 1 as "Filled"
Please help me with this, if there can be any conditional formatting or anything else which can be done to make my matrix visualisation better.
Thank you.
Placing special text thru condiational formatting is not possible as there is already some data is there
Proud to be a Super User!
Is there any other way I can highlight blank cells and add say "0" or "Missing" to them, instead of just blanks, apart from conditional formatting?
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 64 | |
| 51 | |
| 46 | |
| 23 | |
| 19 |
| User | Count |
|---|---|
| 138 | |
| 111 | |
| 50 | |
| 33 | |
| 29 |