Forum Discussion

sklement's avatar
sklement
Frequent Visitor
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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] ) )
)

     

     

     

    Here is the pbix file.

     

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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] ) )
)

 

 

 

Here is the pbix file.

 

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

  • sklement's avatar
    sklement
    Frequent Visitor
    5 years ago

    Many thanks Evelyn! That helped a lot.