cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pankajdeol Frequent Visitor
Frequent Visitor

Line and stacked column chart

Hello Friends, I am new to Power BI and got stuck in my first assignment. Please help. 

I have two tables, in one I have a date column (mm/dd/yyyy hh:mm:ss) and one "Order ID" column. In 2nd table I have one date column(same format), one "Order ID" column and one "Order Type" column. Both tables are for different companies and order id is in diff format. I want to show a combine chart containing a line which shows monthly count of orders from table one and stacked columns showing count of order ID by order type from 2nd table. 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Microsoft v-ljerr-msft
Microsoft

Re: Line and stacked column chart

Hi @pankajdeol,

 

According to your description above, you should be able to follow steps below to create the line and stacked column chart.Smiley Happy

 

1. Create an individual Calendar table using formula below.

 

Date = CALENDARAUTO()

t1.PNG

 

2. Create relationships between the Calendar table and both the two tables with Date columns.

 

r1.PNG

 

3. Use date column from the Calendar table as Shared axis for the chart.

result1.PNG

Regards

View solution in original post

pankajdeol Frequent Visitor
Frequent Visitor

Re: Line and stacked column chart

Thanks v-ljerr. This works great. I have one more doubt if you can help pls. When I am using date as shared axis either it takes month or year. How to display year and Month both and how to sort that as in excel.

View solution in original post

4 REPLIES 4
Microsoft v-ljerr-msft
Microsoft

Re: Line and stacked column chart

Hi @pankajdeol,

 

According to your description above, you should be able to follow steps below to create the line and stacked column chart.Smiley Happy

 

1. Create an individual Calendar table using formula below.

 

Date = CALENDARAUTO()

t1.PNG

 

2. Create relationships between the Calendar table and both the two tables with Date columns.

 

r1.PNG

 

3. Use date column from the Calendar table as Shared axis for the chart.

result1.PNG

Regards

View solution in original post

pankajdeol Frequent Visitor
Frequent Visitor

Re: Line and stacked column chart

Thanks v-ljerr. This works great. I have one more doubt if you can help pls. When I am using date as shared axis either it takes month or year. How to display year and Month both and how to sort that as in excel.

View solution in original post

Microsoft v-ljerr-msft
Microsoft

Re: Line and stacked column chart

Hi @pankajdeol,

 

Just two steps.Smiley Happy

1. Keep only Year and Month for the Date Hierarchy as shared axis.

2. Click "Expand all down one level in the hierarchy" on the left top of the chart.

yearmonth.PNG

 

Regards

pankajdeol Frequent Visitor
Frequent Visitor

Re: Line and stacked column chart

Thanks. you are my saviour 🙂

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)