Can`t put legends in a two measures stacked bar chart

[Carlos_Ponce]

Hi, I have a chart with two measures, one with positive and other with negative values, like this

And the problem is that I can't put the legends of the different items so that each bar is split in differents colors, something like this (I had to put two different charts to do that)

When I have only one measure in the chart i can put legends, but not when I have two measures.

Thanks a lot

[MFelix · Accepted solution]

Hi @Carlos_Ponce ,

You cannnot have legends and more than one measure on the visualizations is one of the limitations, for this to work you would need to have a table with a MGI or using calculation groups so you would have the measures on the calculation and the values on the legends.

[GregGiamz]

Hi all, I've tried the above method which works.
However, I'm looking to add one more Type (legend or if any other field works).
Would it be possible? 

Eg. 
Category 1 - Metric 1 - Type a or b
Category 1 - Metric 2 - Type a or b
Category 1 - Metric 3 - Type a or b
Category 1 - Metric 4 - Type a or b
Category 1 - Metric 5 - Type a or b

[MFelix]

Hi @GregGiamz ,

For this you need to add an hierarchy to the Axis level if the type is a column that is part of your model you just need to add both of then you can drill up and down at each level of the axis.

[GregGiamz]

Appreciate your reply!

I understand what you mean, however, we are looking to have it on the stacked chart like this, instead of multiple hierarchy drill down on the axis level:
would you know if this is possible:

[MFelix]

Hi @GregGiamz ,

Not sure if I understood how you have the data, can you please share a sample data and expected result please.

[MFelix · Accepted solution]

Hi @Carlos_Ponce ,

You cannnot have legends and more than one measure on the visualizations is one of the limitations, for this to work you would need to have a table with a MGI or using calculation groups so you would have the measures on the calculation and the values on the legends.

[Carlos_Ponce]

Hi @MFelix thanks a lot for the answer.

Im a little new in this, what dos it mean table whith MGI? I searched in internet but didnt find it.

[MFelix · Accepted solution]

Hi @Carlos_Ponce ,

MGI is Mother-Generated Index calculation meaning that you would have a table similar to this:

Index	Measure
1	Measure 1
2	Measure 2
3	Measure 3
4	Measure 4

Then using a Switch metric you would pull each metric for the visualization.

Similar to:

Metric Value =

SWITCH (
    SELECTEDVALUE ( Table[Index] ),
    1, [Measure 1],
    2, [Measure 2],
    3, [Measure 3],
    4, [Measure 4]
)

Now if you use the Column on the table on top for the Legend and the Measure to the values you get multiple measures with legend.

It seems to me that you have a variable number of values that will be picked up base on a categorization or something similar, that will be a lot of values and not a small number so would be doable but maybe hard coding a little.