Forum Discussion
Showing Multiple Measure in one bar chart cleanly
Hi ,
Bit of a workaround but you could create a new table (by using Enter Data) with the name of your measures:
Table Name: Aware
Aware Headers:
Aware Brand1
Aware Brand2
Aware Brand3
Aware NoneThen create a switch statement like the below:
SWITCH (
MIN ( 'Aware'[Aware Headers] ),
"Aware Brand1", [Aware Brand1],
"Aware Brand2", [Aware Brand2],
"Aware Brand3", [Aware Brand3],
"Aware None", [Aware None]
)Use the switch statement above as your value and use your Column Headers from the table as your X axis
Hi ,
Bit of a workaround but you could create a new table (by using Enter Data) with the name of your measures:
Table Name: Aware
Aware Headers:
Aware Brand1
Aware Brand2
Aware Brand3
Aware None
Then create a switch statement like the below:
SWITCH (
MIN ( 'Aware'[Aware Headers] ),
"Aware Brand1", [Aware Brand1],
"Aware Brand2", [Aware Brand2],
"Aware Brand3", [Aware Brand3],
"Aware None", [Aware None]
)
Use the switch statement above as your value and use your Column Headers from the table as your X axis
This probably won't be replied to, but I'll try. I saw this looking or a similar problem I have, and this worked as it created the bars separated with the X axis labels, howver, the filters I created (month and date), don't modify these bars. How can I do it so the "switch" column varies when varying the filters?