Forum Discussion

dpc_development's avatar
dpc_development
Helper III
7 years ago
Solved

Custom Visualisation for multiple legends and values

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 overc...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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's avatar
v-juanli-msft
Community Support
7 years ago

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.