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.

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: