Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
I am trying the use a column as legend in donut chart. The column value has nulls too.
I want to change the "nulls" to "Not Specified" just for the donut chart instead of transforming it in the dataset. Is that possible using DAX or something?
Please Help.
Thank you in advance, Sir.
Solved! Go to Solution.
hello just add a new calculated column to your tble
New Column =
SWITCH(
TRUE(),
'Table'[Category] = BLANK(),"Not Specified",
'Table'[Category]
)
using measures isnt possible for now
hello just add a new calculated column to your tble
New Column =
SWITCH(
TRUE(),
'Table'[Category] = BLANK(),"Not Specified",
'Table'[Category]
)
using measures isnt possible for now
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 4 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 13 | |
| 9 | |
| 9 | |
| 8 | |
| 7 |