Combine two visuals on one Clustered Column Chart

Question

Is it possible to get two visuals onto one Clustered Column Chart?So if I show Years on the X Axis I will see two columns for each year, with each column having its own set of Filters.&nbsp;&nbsp;

pijushroy · Answer

Hi&nbsp;bdehning&nbsp;Please share supporting screenshots for sample Data and visual you have and the expected visual.Please show the expected outcome based on the sample data you provided. Find how to provide sample datahttps://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216How to get answered quicklyhttps://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523&nbsp;Appreciate your KUDOSThanksPijush

zenisekd · Answer

This is rather problematic, you may have various valuses in those columns, which means 2 axis might be needed. You may calculate a table where you append those columns so it could be used the way you need, in a clustered bar chart.&nbsp;However, to solve this easy way, I would suggest you use line and clustered barchart....

anonymous · Answer

Hi&nbsp;bdehning&nbsp;,Please tell me is this the result you expect to get?Here is my sample data:

&nbsp;

I created two measures and put them into the Clustered Column Chart to exist as values:
SUM = CALCULATE(
    SUM('Table'[Value]),
    FILTER(
        'Table',
        'Table'[ID] = SELECTEDVALUE('Table (2)'[ID_SUM])
    )
)AVERAGE = CALCULATE(
    AVERAGE('Table'[Value]),
    FILTER(
        'Table',
        'Table'[ID] = SELECTEDVALUE('Table (3)'[ID_AVERAGE])
    )
)
Create a slicer based on table (2) and table (3) respectively.&nbsp;The results are as follows:

&nbsp;

Best Regards,Dino TaoIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

bdehning · Answer

Let me review when I get some time later this week as it looks promising.&nbsp; &nbsp;

Forum Discussion

Combine two visuals on one Clustered Column Chart

Related content

Tables combine

How to combine a stacked and clustered column chart

Combine Cluster and Stacked Bar Charts

Clustered column chart incomplete legend

How to combine to matrix visuals