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.
Hi BI pros,
I am new to Power BI and still learning. So this might be a silly question:
I wanted to have a simple graph with temperatures all over the year, but on a day by day line or dots (not only month sum or average). But how its done in BI to see the line chart this way?
In addition, the sales should be assigned to this chart, in order to get an idea of how sales increases while the sun is out 🙂
many thanks for your help
Solved! Go to Solution.
Hi @sklement ,
According to my understand, you want to display total sales and temperature of each day , right?
1. Date as X-axis :
You could use Drill-down or as @amitchandak said, set X-axis as Categorical like this:
2.To show sales : You could use the following formula to calculate the sum and then drag it to Tooltip/Size pane like this:
Total Sales =
CALCULATE (
SUM ( Sale[Sales] ),
FILTER ( 'Sale', 'Sale'[Date] = MAX ( 'Table'[Date] ) )
)
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Hi @sklement ,
According to my understand, you want to display total sales and temperature of each day , right?
1. Date as X-axis :
You could use Drill-down or as @amitchandak said, set X-axis as Categorical like this:
2.To show sales : You could use the following formula to calculate the sum and then drag it to Tooltip/Size pane like this:
Total Sales =
CALCULATE (
SUM ( Sale[Sales] ),
FILTER ( 'Sale', 'Sale'[Date] = MAX ( 'Table'[Date] ) )
)
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Many thanks Evelyn! That helped a lot.
@sklement , you can plot by date or datetime as a continuous axis. Summarization is compulsory in live visual for values
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 |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |