Creating a Combo chart in Power BI

[Anonymous]

Hello,

Hello all!

New PowerBI user here. I have always created my reports in Excel. 

I am trying to recreate the below viz in Power BI. I've tried using the Line and clustered column chart but I cannot make the line display the dates as shown in the screenshot below.

The data below is just a chunk of the data that I am working on and am hoping to create a condition based on timeline for PBI to automatically pull data for # columns for next 6 months or the 6-12 months after that and so on.

Any and all help is appreciated!

Best,

PBINooB

[Anonymous]

Hi @Anonymous ,

To my knowledge, currently the Y-Axis only allows for aggregates of number values ,Date type values are not available.

Below are serveral submitted ideas, you could vote them up and add comments:

dates and times on the y-axis of a graph

Add feature to display time on Y axis to compare against Date on X axis

As a workaround , you could apply Date to Tooltips or as @AlexisOlson mentioned, change the Date to Number type.

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

[AlexisOlson · Accepted solution]

You can get close but it seems that the chart doesn't like to use dates other than on the x-axis so you have to convert them to some numeric type.

[Anonymous]

This looks great Alexis! Could you please share how to do this?

[AlexisOlson]

I used INT ( MAX ( Data[Date] ) ) for the line measure definition.

[Anonymous]

Could you share a screenshot? I only have drag and drop fields when trying to modify a "line and clustered column chart"

[AlexisOlson]

You need to define a measure to use for the date (use the DAX I mentioned previously to define it).