cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ivyhai
Post Patron
Post Patron

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

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

Power bi test.PNG

1 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:

15.PNG16.PNG17.PNG

 

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

Regards

View solution in original post

4 REPLIES 4
ankitpatira
Community Champion
Community Champion

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

 

capture.png

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

Power bi test.PNG

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:

15.PNG16.PNG17.PNG

 

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

Regards

View solution in original post

but it just not working here. Power bi test.PNG

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors