Clustered Column Chart - More than one value for the same Legend

[Anonymous]

Hi everyone!

I'm trying to display 2 values (cost, monetarily updated cost) for 2 different kinds of matterial (paper type 1, paper type 2) along time.

I'd like to display these values using a clustered column chart, with time on x-axis and values on y-axis. That would give me 4 bars for each x-axis element (each month):

1. Cost for paper type 1
2. Updated cost for paper type 1
3. Cost for paper type 2
4. Updated cost for paper type 2

All the information needed is stored in a single table (ConsolidadoGeral), as seen bellow:

Table "ConsolidadoGeral": The first highlighted field registers the paper type (only 2, in this case), the second highlighted field register the data (x-axis), and the two last highlighted field registers the cost and updated cost

I've tried to set the clustered bar graph with these configuration:

• Axis: the date field
• Legend: the paper type field "Descrição do material" field
• Value: The cost field ("Valor") and the updated cost field ("ValorAtualizadoCol")

The problem: Power BI only allows me to drag two fields into value attribute if there is no legend field, in such a way that I can only display the information for cost or updated cost, as shown bellow:

The problem: Wish I could display the two graphs in only one, showing 4 bars per x-axis pointView configuration: can't drag more than one field to "value" parameter

Can I show the cost AND updated cost in the same graph, divided by paper type ("Descrição do material" field), i.e., 4 bars for each x-axis point?

Any help is welcome!

Thanks in advance.

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

If you want to show 4 bars, you have to need 2 new legends "Descrição do material".

You could copy your original table in the query editor and edit the "Descrição do material" column in the copy table. Then append these two tables as a new table.