How to merge 2 charts into 1 or how to show 2 columns in 1 chart

[Anonymous]

The values are from 1 table but 2 columns, how to present those 2 columns into 1 chart?

[ankitpatira]

@Anonymous You can drop two columns onto Axis area and you will get drill down of those columns in the chart. So on top right hand corner you will get drilldown icon which when turned on you can click on column and it will drill down onto next column.

[Anonymous]

@ankitpatira the data i'm using is export file from survey see below

[v-micsh-msft · Accepted solution]

Hi ivyhai,

To have two column showing in the same column chart, the column item should meet the following requirements:

1. They are under same scale, and should stand for different range;
2. They could share one scale standard;
3. Under Power BI visual, the Axis well should be put with one column

So I think show the wanted result, we need to modeling the data before we use it. Could you please tell more details about the current table?

Modeling

https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-2-1-intro-modeling-data/

Based your data table, we could rebuild the data using the following way:

Case ID	Status name
1	I donated ###
1	I trust ####
2	I donated ###
2	I trust ###
3	I care deeply ##

Using this data sample, we could organize the Status name easier and control how many items should be shown as column value using Filter.

And based on your data source, under Query Editor, we could format the table with the following ways:

1. Under Query Editor, right click the table and choose Duplicate the table, with a number of your status listed;

2. Under each table, leaves only one special status column, and delete the other status columns;

3. And if you would like to remove the empty value under the status column, click the dropdown box and select remove empty;

4. Change the only left status column name to Status or something else (Must be the same one in all tables) within all the Duplicate table;

5. Select one table, then under home tab, click append queries, then select all the duplicate tables, click OK.

See example:

Please take a try to format the data source, and if any further assistance needed, please feel free to post back.

Regards

[Anonymous]

but it just not working here.