Merge two Visuals

[Junaid72]

Number of itemsValue of Items

Hi Guys,

I am trying to merge two visuals into one, is this possible? Date is a common value between the two.

Not sure where to start and how could i end up with a stacked column that displays btoh number of items along with values outstanding for a distinct days?

Thanks

[v-yulgu-msft · Accepted solution]

Hi @Junaid72,

Suppose your source table structure is similar to:

Please insert a clustered and column bar chart, please field [Day] (or may be date hierarchy in your scenario) into "Axis" section. Then, drag [item] with "Count" aggregation and [value] with "Sum" aggregation into "Value" section.

Best regards,

Yuliana Gu