Cluster and Stacked Bar Chart Challenge

[deeave]

I created a stack bar chart with several measures.  My goal is to have Pipeline bar include Ideas, New Tech and Discovery and the In-Flight all others.

What I've done so far:

• Created 7 different calculated items referncing the measures

• In the Model, I added a column that references each calculated item to the type that it belongs to: 

I updated all measures to include the type:  sample below

The stacked bar chart will NOT allow me to move the type to legend.  I love the chart as it is, but want the designated measures to display in their respected bar.  What am I missing?

[lbendlin · Accepted solution]

If you want a legend you need to provide a single measure.

[deeave · Accepted solution]

Right before you replied, I figured it out by adding a measure!  🙂

[lbendlin · Accepted solution]

If you want a legend you need to provide a single measure.