How to use ISFILTERED for clustered column chart?

[afaro]

I am currently using something like this: 

SWITCH(TRUE(),

ISFILTERED(X), Y,

ISFILTERED(Z), A) 

I need to see more than one output if something is filtered since it is a clustered column chart. How do I do this ?

[v-zhouwen-msft · Accepted solution]

Hi @afaro ,

Regarding your question, are you trying to display multiple columns in a clustered bar chart by returning multiple values for a single measure?

After my testing, this doesn't seem to be possible due to the fact that only one value can be returned for a single measure. Also only a separate column can be generated. The y-axis of the clustered bar chart does not accept data of type 'Text' after stitching multiple values into a string.So my suggestion is to create multiple measures.

Measure = IF(ISFILTERED('Table'[Amount]),SUM('Table'[Amount]))

Measure 2 = IF(ISFILTERED('Table'[ID]),MAX('Table'[ID]))