Forum Discussion

Junaid72's avatar
Junaid72
Frequent Visitor
8 years ago
Solved

Merge two Visuals

  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...
Need Help
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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