Custom Visualisation for multiple legends and values

[dpc_development]

I realise that the default Area Chart in Power BI does not let you add more than one Legend and Values at the same time, but was wondering whether anyone may have made a custom visualisation to overcome this.

Looking for a suggested custom visualisation that plots more than one legend and more than one value metric at the same time, as an area chart.

I browsed through the list of custom visualisations and personally was not able to find one.

[v-juanli-msft · Accepted solution]

Hi @dpc_development 

1. In Edit queries, select columns "cr" and "relative cr" , select "Transform->Unpivot columns",Then i get the table as below

2. Select two columns "Attribute" and "item":

click on "Attribute" first, keep "Ctrl" button pressed, then click on "item".

then select "merge columns"

CLOSE &&APPLY

3.

You could use Line chart or area chart

Go to "Format" pane,

you could change the position of the legend in the Legend property, 

Change the color in in the Data color property

 

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft]

Hi @dpc_development 

As searched, i can't find any visual as you said.

Could you share some example data and draw a simple picture to show your expected visual so that i may work out with a workaround?

Best Regrads

Maggie

[dpc_development]

Hi Maggie ( @v-juanli-msft ). I uploaded a sample here.

I guess one work around would be to  re-organise the data with the metric name and legend name concatenated.

However, was hoping there'd be an easier solution that sets the colour of the legend the same for both values/metrics.

[v-juanli-msft]

Hi @dpc_development 

Is this problem sloved?

If not, please let me know.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.