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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

sklement , you can plot by date or datetime as a continuous axis. Summarization is compulsory in live visual for values