Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 ?
Solved! Go to 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]))
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]))
User | Count |
---|---|
21 | |
20 | |
12 | |
10 | |
8 |
User | Count |
---|---|
30 | |
28 | |
14 | |
13 | |
11 |