Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Cool dude.
It is very simple. do the following steps
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!
Cool dude.
It is very simple. do the following steps
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
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!
Thank you very much, Your solution is very helpful
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
64 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |