The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
14 | |
14 | |
9 | |
7 |