Combine two visuals on one Clustered Column Chart

[bdehning]

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.  

[bdehning]

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

[v-junyant-msft]

Hi @bdehning ,

Please tell me is this the result you expect to get?
Here is my sample data:

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. The results are as follows:

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

[zenisekd]

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....

[PijushRoy]

Hi @bdehning 

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 data
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

How to get answered quickly
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Appreciate your KUDOS

Thanks
Pijush