Forum Discussion

deeave's avatar
deeave
Icon for Helper I rankHelper I
2 years ago
Solved

Cluster and Stacked Bar Chart Challenge

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?

 

 

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

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

2 Replies

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

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