Forum Discussion
Creating a Combo chart in Power BI
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
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.
6 Replies
- AlexisOlson
Super User
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.
- AlexisOlson
I used INT ( MAX ( Data[Date] ) ) for the line measure definition.
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.