How to use ISFILTERED for clustered column chart?

afaro — Thu, 16 May 2024 18:47:49 GMT

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 ?

Re: How to use ISFILTERED for clustered column chart?

Anonymous — Fri, 17 May 2024 02:06:49 GMT

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]))

topic Re: How to use ISFILTERED for clustered column chart? in DAX Commands and Tips

How to use ISFILTERED for clustered column chart?

Re: How to use ISFILTERED for clustered column chart?