Forum Discussion
How to do it in PBI Desktop?
Hello, I have a data set like below - Year, Month, Company and Revenue
I am able to do it just simply click to generate the right-hand side's chart. However, I don't know how to use it in BI. I am confused by the "Fields".
Thank you for your concern and look forward to your reply.
Lawrence
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:
5 Replies
- Baskar
Resident Rockstar
Cool 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
