Column filter

[Anonymous]

hi, 

a basic quick question, 

if I have a column  A , and column A returns either 'b' and 'c', but I want to show them both on a pie chart, 

how do I go about it?

I have applied 

bA = (tablename[A] ), 'b'

cA = (tablename[A] ), 'c'

where am I wrong?

[PattemManohar · Accepted solution]

@Anonymous "Flag" is an calculated column name (you can name it as you like) which will have either Pass or Failed values based on values present in another field i.e. ColumnA as mentioned above. You need to use this new calculated column i.e. "Flag" in your pie-chart. Hope this helps !!

[v-yuta-msft]

Hi atrinhatra,

A pie chart at least needs two columns, value column and legend column, if columnA is a category column, put columnA to legend field and another column to value field.

 

Regards,

Jimmy Tao

[Anonymous]

You may have missundrestood my question. 

columnA returns 'yes' or 'no'

but I want to show if columnA = 'yes' show 'pass'

if columnA = 'no' show 'failed' 

another word , I am asking the DAX syntax of above 

[PattemManohar]

@Anonymous Is this what you are looking for ? Try this as a new column

Flag = SWITCH(TRUE(),Table[ColumnA]="Yes","Pass",Table[ColumnA]="No","Failed")

[Anonymous]

Thanks, Yes thats what I am after, however what does FLag represents? the code gives an error " THE syntax for 'FLag' in incorrect, (DAX(..........

[PattemManohar · Accepted solution]

@Anonymous "Flag" is an calculated column name (you can name it as you like) which will have either Pass or Failed values based on values present in another field i.e. ColumnA as mentioned above. You need to use this new calculated column i.e. "Flag" in your pie-chart. Hope this helps !!

[Anonymous · Accepted solution]

Thanks, 

for some reasons I still get syntax error on the logic but I belive this is what I need,