Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sklement
Frequent Visitor

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

1 ACCEPTED SOLUTION
v-eqin-msft
Community Support
Community Support

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:

 

11.26.5.1.gif

 

 

 

 

 

 

 

11.26.5.2.gif

 

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

 

 

 

11.26.5.3.jpg11.26.5.4.jpg

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

View solution in original post

3 REPLIES 3
v-eqin-msft
Community Support
Community Support

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:

 

11.26.5.1.gif

 

 

 

 

 

 

 

11.26.5.2.gif

 

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

 

 

 

11.26.5.3.jpg11.26.5.4.jpg

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

Many thanks Evelyn! That helped a lot.

amitchandak
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.