Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
gantaran
Regular Visitor

Month-to-Date Daily Bar Chart

‎10-10-2024 06:14 PM

I'd like to show the MTD daily sales in a bar chart.  For example, if I select the date Sept 15, 2024, the visual will show the daily sales from Sept 1 to 15.  How do I do that?

Message 1 of 8
882 Views
0
2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User
In response to gantaran

‎10-14-2024 06:52 AM

see attached.  Not sure if that is a good UX.

View solution in original post

month to date.pbix
Message 4 of 8
745 Views
lbendlin
Super User
Super User
In response to gantaran

‎10-15-2024 08:51 AM

 

Net Gen YTD = 
var d = max('Calendar'[Date])
var fd = max('Table'[Date])
return if(format(fd,"mmdd")<=format(d,"mmdd") && year(fd)=year(d),SUM('Table'[Net Generation]))

 

View solution in original post

Message 7 of 8
667 Views
0
7 REPLIES 7
gantaran
Regular Visitor

‎10-15-2024 12:33 AM

Hi, can you also help me with another visual showing YTD daily values?  that is, if I select Aug 7, it will show cumulative values from Jan 1 to Aug 7. you may use the same sample data.  

Message 6 of 8
689 Views
0
lbendlin
Super User
Super User
In response to gantaran

‎10-15-2024 08:51 AM

 

Net Gen YTD = 
var d = max('Calendar'[Date])
var fd = max('Table'[Date])
return if(format(fd,"mmdd")<=format(d,"mmdd") && year(fd)=year(d),SUM('Table'[Net Generation]))

 

Message 7 of 8
668 Views
0
gantaran
Regular Visitor
In response to lbendlin

‎10-15-2024 10:34 PM

Thanks again!

Message 8 of 8
635 Views
0
lbendlin
Super User
Super User

‎10-11-2024 02:31 PM

Have you tried to use a Quick Measure? They have patterns for that.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Message 2 of 8
819 Views
0
gantaran
Regular Visitor
In response to lbendlin

‎10-13-2024 06:40 PM

Here's the sample data.

 

Source.NameDatePlant UnitNet Generation
240701_IPP.csv07/01/2024PLANT18100.876
240702_IPP.csv07/02/2024PLANT16096.528
240703_IPP.csv07/03/2024PLANT18507.088
240704_IPP.csv07/04/2024PLANT13133.128
240705_IPP.csv07/05/2024PLANT17911.468
240706_IPP.csv07/06/2024PLANT17960.536
240707_IPP.csv07/07/2024PLANT17956.636
240708_IPP.csv07/08/2024PLANT110809.6
240709_IPP.csv07/09/2024PLANT111378.076
240710_IPP.csv07/10/2024PLANT16898.116
240711_IPP.csv07/11/2024PLANT17963.404
240712_IPP.csv07/12/2024PLANT18045.604
240713_IPP.csv07/13/2024PLANT18801.148
240714_IPP.csv07/14/2024PLANT18004.972
240715_IPP.csv07/15/2024PLANT18893.236
240716_IPP.csv07/16/2024PLANT19182.988
240717_IPP.csv07/17/2024PLANT19856.368
240718_IPP.csv07/18/2024PLANT111901.648
240719_IPP.csv07/19/2024PLANT114123.724
240720_IPP.csv07/20/2024PLANT114073.456
240721_IPP.csv07/21/2024PLANT114086.476
240722_IPP.csv07/22/2024PLANT113845.252
240723_IPP.csv07/23/2024PLANT113651.488
240724_IPP.csv07/24/2024PLANT17933.74
240725_IPP.csv07/25/2024PLANT17962.516
240726_IPP.csv07/26/2024PLANT17968.432
240727_IPP.csv07/27/2024PLANT17943.352
240728_IPP.csv07/28/2024PLANT17917.732
240729_IPP.csv07/29/2024PLANT18225.088
240730_IPP.csv07/30/2024PLANT19136.428
240731_IPP.csv07/31/2024PLANT19829.529033
240801_IPP.csv08/01/2024PLANT18892.744
240802_IPP.csv08/02/2024PLANT18871.216
240803_IPP.csv08/03/2024PLANT17885.212
240804_IPP.csv08/04/2024PLANT19700.008
240805_IPP.csv08/05/2024PLANT113981.548
240806_IPP.csv08/06/2024PLANT114025.168
240807_IPP.csv08/07/2024PLANT114000.76
240808_IPP.csv08/08/2024PLANT113938.684
240809_IPP.csv08/09/2024PLANT113902.528
240810_IPP.csv08/10/2024PLANT113899.024
240811_IPP.csv08/11/2024PLANT113932.72
240812_IPP.csv08/12/2024PLANT113915.788
240813_IPP.csv08/13/2024PLANT113893.06
240814_IPP.csv08/14/2024PLANT113931.328
240815_IPP.csv08/15/2024PLANT113917.48
240816_IPP.csv08/16/2024PLANT113922.604
240817_IPP.csv08/17/2024PLANT113864.608
240818_IPP.csv08/18/2024PLANT113880.796
240819_IPP.csv08/19/2024PLANT113934.592
240820_IPP.csv08/20/2024PLANT113928.82
240821_IPP.csv08/21/2024PLANT113944.204
240822_IPP.csv08/22/2024PLANT113938.504
240823_IPP.csv08/23/2024PLANT113837.86
240824_IPP.csv08/24/2024PLANT113869.996
240825_IPP.csv08/25/2024PLANT113872.504
240826_IPP.csv08/26/2024PLANT113822.596
240827_IPP.csv08/27/2024PLANT113795.524
240828_IPP.csv08/28/2024PLANT113746.492
240829_IPP.csv08/29/2024PLANT113799.412
240830_IPP.csv08/30/2024PLANT113790.76
240831_IPP.csv08/31/2024PLANT113818.948
240901_IPP.csv09/01/2024PLANT113782.096
240902_IPP.csv09/02/2024PLANT113766.628
240903_IPP.csv09/03/2024PLANT113759.2
240904_IPP.csv09/04/2024PLANT113788.804
240905_IPP.csv09/05/2024PLANT113820.676
240906_IPP.csv09/06/2024PLANT113759.2
240907_IPP.csv09/07/2024PLANT113824.312
240908_IPP.csv09/08/2024PLANT113827.816
240909_IPP.csv09/09/2024PLANT113827.588
240910_IPP.csv09/10/2024PLANT113793
240911_IPP.csv09/11/2024PLANT113811.34
240912_IPP.csv09/12/2024PLANT113797.48
240913_IPP.csv09/13/2024PLANT112163.92
240914_IPP.csv09/14/2024PLANT17247.179707
240915_IPP.csv09/15/2024PLANT17965.06
240916_IPP.csv09/16/2024PLANT17983.804
240917_IPP.csv09/17/2024PLANT17977.432
240918_IPP.csv09/18/2024PLANT17955.76
240919_IPP.csv09/19/2024PLANT18068.032
240920_IPP.csv09/20/2024PLANT17964.628
240921_IPP.csv09/21/2024PLANT17869.156
240922_IPP.csv09/22/2024PLANT16842.448
240923_IPP.csv09/23/2024PLANT18127.228
240924_IPP.csv09/24/2024PLANT18148.468
240925_IPP.csv09/25/2024PLANT18930.34
240926_IPP.csv09/26/2024PLANT18996.472
240927_IPP.csv09/27/2024PLANT110529.904
240928_IPP.csv09/28/2024PLANT113378.644
240929_IPP.csv09/29/2024PLANT110730.532
241001_IPP.csv09/30/2024PLANT17968.408
240801_Ilijan.csv08/15/2024PLANT113917.48

 

The expected visual should be:
If I select the date July 15, 2024, it will show a bar graph showing 15 bars representing the net generation values from July 1 to 15.  If I select Aug 7, it will show a bar graph showing 7 bars representing the net generation values from Aug 1 to 7. 

Message 3 of 8
764 Views
0
lbendlin
Super User
Super User
In response to gantaran

‎10-14-2024 06:52 AM

see attached.  Not sure if that is a good UX.

month to date.pbix
Message 4 of 8
746 Views
gantaran
Regular Visitor
In response to lbendlin

‎10-14-2024 06:08 PM

Thank you so much.  This is what I needed.

Message 5 of 8
712 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All
Top Kudoed Authors
View All