Forum Discussion
Month and Days
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
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
3 Replies
- amitchandak
Super User
sklement , you can plot by date or datetime as a continuous axis. Summarization is compulsory in live visual for values
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 QinMany thanks Evelyn! That helped a lot.
