Forum Discussion

P0werBIn00b's avatar
P0werBIn00b
Icon for Helper I rankHelper I
3 years ago
Solved

Change a row value for a single visual using DAX

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 data...
CHANGE ROW VALUE
DAX
legend
  • eliasayyy's avatar
    eliasayyy
    3 years ago

    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

eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

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