Forum Discussion
How to do it in PBI Desktop?
Cool dude.
It is very simple. do the following steps
1
2
3
Let me know if any help needed
The other thing I would suggest you do is create a Calculated Column Date in your table
Date = 'Table'[Month] & "/1/" & 'Table'[Year]
Then change the Data Type in the Modeling Tab to Date
Now because this Column is of Data Type - Date you'll get a nicer Date Hierarchy
So go back to chart and drag the Date Column to the Axis field - get rid of Quarter and Day
And the use the drill down button in the top left corner of the chart to go to the lowest level
Hope this helps! :smileyhappy:
Resident RockstarCool dude.
It is very simple. do the following steps
1
2
3
Let me know if any help needed
Thank you Baskar, your explanation is very clear.
Further more, if I have more than 1 company (ABC & DEF) in the data set, how to do the line chart in the same time line, like below:
Thank you very much and look forawrd to your reply.
Lawrence
SeanCommunity Champion
- Sean
The other thing I would suggest you do is create a Calculated Column Date in your table
Date = 'Table'[Month] & "/1/" & 'Table'[Year]
Then change the Data Type in the Modeling Tab to Date
Now because this Column is of Data Type - Date you'll get a nicer Date Hierarchy
So go back to chart and drag the Date Column to the Axis field - get rid of Quarter and Day
And the use the drill down button in the top left corner of the chart to go to the lowest level
Hope this helps! :smileyhappy:
Thank you very much, Your solution is very helpful:smileyhappy: