topic Re: Month-to-Date Daily Bar Chart in Custom Visuals Development Discussion https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4241524#M11567 <P>see attached.&nbsp; Not sure if that is a good UX.</P> Mon, 14 Oct 2024 13:52:23 GMT lbendlin 2024-10-14T13:52:23Z Month-to-Date Daily Bar Chart https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4237778#M11537 <P>I'd like to show the MTD daily sales in a bar chart.&nbsp; For example, if I select the date Sept 15, 2024, the visual will show the daily sales from Sept 1 to 15.&nbsp; How do I do that?</P> Fri, 11 Oct 2024 01:14:53 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4237778#M11537 gantaran 2024-10-11T01:14:53Z Re: Month-to-Date Daily Bar Chart https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4239310#M11545 <P>Have you tried to use a Quick Measure? They have patterns for that.</P> <P>&nbsp;</P> <P>Please provide sample data that covers your issue or question <STRONG>completely</STRONG>, in a <STRONG>usable</STRONG> format (not as a screenshot).<BR /><BR />Do not include sensitive information. Do not include anything that is unrelated to the issue or question. <BR /><BR />Need help uploading data? <A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR /><BR />Please show the expected outcome based on the sample data you provided. <BR /><BR />Want faster answers? <A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Fri, 11 Oct 2024 21:31:06 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4239310#M11545 lbendlin 2024-10-11T21:31:06Z Re: Month-to-Date Daily Bar Chart https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4240310#M11562 <P>Here's the sample data.</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Source.Name</TD><TD>Date</TD><TD>Plant Unit</TD><TD>Net Generation</TD></TR><TR><TD>240701_IPP.csv</TD><TD>07/01/2024</TD><TD>PLANT1</TD><TD>8100.876</TD></TR><TR><TD>240702_IPP.csv</TD><TD>07/02/2024</TD><TD>PLANT1</TD><TD>6096.528</TD></TR><TR><TD>240703_IPP.csv</TD><TD>07/03/2024</TD><TD>PLANT1</TD><TD>8507.088</TD></TR><TR><TD>240704_IPP.csv</TD><TD>07/04/2024</TD><TD>PLANT1</TD><TD>3133.128</TD></TR><TR><TD>240705_IPP.csv</TD><TD>07/05/2024</TD><TD>PLANT1</TD><TD>7911.468</TD></TR><TR><TD>240706_IPP.csv</TD><TD>07/06/2024</TD><TD>PLANT1</TD><TD>7960.536</TD></TR><TR><TD>240707_IPP.csv</TD><TD>07/07/2024</TD><TD>PLANT1</TD><TD>7956.636</TD></TR><TR><TD>240708_IPP.csv</TD><TD>07/08/2024</TD><TD>PLANT1</TD><TD>10809.6</TD></TR><TR><TD>240709_IPP.csv</TD><TD>07/09/2024</TD><TD>PLANT1</TD><TD>11378.076</TD></TR><TR><TD>240710_IPP.csv</TD><TD>07/10/2024</TD><TD>PLANT1</TD><TD>6898.116</TD></TR><TR><TD>240711_IPP.csv</TD><TD>07/11/2024</TD><TD>PLANT1</TD><TD>7963.404</TD></TR><TR><TD>240712_IPP.csv</TD><TD>07/12/2024</TD><TD>PLANT1</TD><TD>8045.604</TD></TR><TR><TD>240713_IPP.csv</TD><TD>07/13/2024</TD><TD>PLANT1</TD><TD>8801.148</TD></TR><TR><TD>240714_IPP.csv</TD><TD>07/14/2024</TD><TD>PLANT1</TD><TD>8004.972</TD></TR><TR><TD>240715_IPP.csv</TD><TD>07/15/2024</TD><TD>PLANT1</TD><TD>8893.236</TD></TR><TR><TD>240716_IPP.csv</TD><TD>07/16/2024</TD><TD>PLANT1</TD><TD>9182.988</TD></TR><TR><TD>240717_IPP.csv</TD><TD>07/17/2024</TD><TD>PLANT1</TD><TD>9856.368</TD></TR><TR><TD>240718_IPP.csv</TD><TD>07/18/2024</TD><TD>PLANT1</TD><TD>11901.648</TD></TR><TR><TD>240719_IPP.csv</TD><TD>07/19/2024</TD><TD>PLANT1</TD><TD>14123.724</TD></TR><TR><TD>240720_IPP.csv</TD><TD>07/20/2024</TD><TD>PLANT1</TD><TD>14073.456</TD></TR><TR><TD>240721_IPP.csv</TD><TD>07/21/2024</TD><TD>PLANT1</TD><TD>14086.476</TD></TR><TR><TD>240722_IPP.csv</TD><TD>07/22/2024</TD><TD>PLANT1</TD><TD>13845.252</TD></TR><TR><TD>240723_IPP.csv</TD><TD>07/23/2024</TD><TD>PLANT1</TD><TD>13651.488</TD></TR><TR><TD>240724_IPP.csv</TD><TD>07/24/2024</TD><TD>PLANT1</TD><TD>7933.74</TD></TR><TR><TD>240725_IPP.csv</TD><TD>07/25/2024</TD><TD>PLANT1</TD><TD>7962.516</TD></TR><TR><TD>240726_IPP.csv</TD><TD>07/26/2024</TD><TD>PLANT1</TD><TD>7968.432</TD></TR><TR><TD>240727_IPP.csv</TD><TD>07/27/2024</TD><TD>PLANT1</TD><TD>7943.352</TD></TR><TR><TD>240728_IPP.csv</TD><TD>07/28/2024</TD><TD>PLANT1</TD><TD>7917.732</TD></TR><TR><TD>240729_IPP.csv</TD><TD>07/29/2024</TD><TD>PLANT1</TD><TD>8225.088</TD></TR><TR><TD>240730_IPP.csv</TD><TD>07/30/2024</TD><TD>PLANT1</TD><TD>9136.428</TD></TR><TR><TD>240731_IPP.csv</TD><TD>07/31/2024</TD><TD>PLANT1</TD><TD>9829.529033</TD></TR><TR><TD>240801_IPP.csv</TD><TD>08/01/2024</TD><TD>PLANT1</TD><TD>8892.744</TD></TR><TR><TD>240802_IPP.csv</TD><TD>08/02/2024</TD><TD>PLANT1</TD><TD>8871.216</TD></TR><TR><TD>240803_IPP.csv</TD><TD>08/03/2024</TD><TD>PLANT1</TD><TD>7885.212</TD></TR><TR><TD>240804_IPP.csv</TD><TD>08/04/2024</TD><TD>PLANT1</TD><TD>9700.008</TD></TR><TR><TD>240805_IPP.csv</TD><TD>08/05/2024</TD><TD>PLANT1</TD><TD>13981.548</TD></TR><TR><TD>240806_IPP.csv</TD><TD>08/06/2024</TD><TD>PLANT1</TD><TD>14025.168</TD></TR><TR><TD>240807_IPP.csv</TD><TD>08/07/2024</TD><TD>PLANT1</TD><TD>14000.76</TD></TR><TR><TD>240808_IPP.csv</TD><TD>08/08/2024</TD><TD>PLANT1</TD><TD>13938.684</TD></TR><TR><TD>240809_IPP.csv</TD><TD>08/09/2024</TD><TD>PLANT1</TD><TD>13902.528</TD></TR><TR><TD>240810_IPP.csv</TD><TD>08/10/2024</TD><TD>PLANT1</TD><TD>13899.024</TD></TR><TR><TD>240811_IPP.csv</TD><TD>08/11/2024</TD><TD>PLANT1</TD><TD>13932.72</TD></TR><TR><TD>240812_IPP.csv</TD><TD>08/12/2024</TD><TD>PLANT1</TD><TD>13915.788</TD></TR><TR><TD>240813_IPP.csv</TD><TD>08/13/2024</TD><TD>PLANT1</TD><TD>13893.06</TD></TR><TR><TD>240814_IPP.csv</TD><TD>08/14/2024</TD><TD>PLANT1</TD><TD>13931.328</TD></TR><TR><TD>240815_IPP.csv</TD><TD>08/15/2024</TD><TD>PLANT1</TD><TD>13917.48</TD></TR><TR><TD>240816_IPP.csv</TD><TD>08/16/2024</TD><TD>PLANT1</TD><TD>13922.604</TD></TR><TR><TD>240817_IPP.csv</TD><TD>08/17/2024</TD><TD>PLANT1</TD><TD>13864.608</TD></TR><TR><TD>240818_IPP.csv</TD><TD>08/18/2024</TD><TD>PLANT1</TD><TD>13880.796</TD></TR><TR><TD>240819_IPP.csv</TD><TD>08/19/2024</TD><TD>PLANT1</TD><TD>13934.592</TD></TR><TR><TD>240820_IPP.csv</TD><TD>08/20/2024</TD><TD>PLANT1</TD><TD>13928.82</TD></TR><TR><TD>240821_IPP.csv</TD><TD>08/21/2024</TD><TD>PLANT1</TD><TD>13944.204</TD></TR><TR><TD>240822_IPP.csv</TD><TD>08/22/2024</TD><TD>PLANT1</TD><TD>13938.504</TD></TR><TR><TD>240823_IPP.csv</TD><TD>08/23/2024</TD><TD>PLANT1</TD><TD>13837.86</TD></TR><TR><TD>240824_IPP.csv</TD><TD>08/24/2024</TD><TD>PLANT1</TD><TD>13869.996</TD></TR><TR><TD>240825_IPP.csv</TD><TD>08/25/2024</TD><TD>PLANT1</TD><TD>13872.504</TD></TR><TR><TD>240826_IPP.csv</TD><TD>08/26/2024</TD><TD>PLANT1</TD><TD>13822.596</TD></TR><TR><TD>240827_IPP.csv</TD><TD>08/27/2024</TD><TD>PLANT1</TD><TD>13795.524</TD></TR><TR><TD>240828_IPP.csv</TD><TD>08/28/2024</TD><TD>PLANT1</TD><TD>13746.492</TD></TR><TR><TD>240829_IPP.csv</TD><TD>08/29/2024</TD><TD>PLANT1</TD><TD>13799.412</TD></TR><TR><TD>240830_IPP.csv</TD><TD>08/30/2024</TD><TD>PLANT1</TD><TD>13790.76</TD></TR><TR><TD>240831_IPP.csv</TD><TD>08/31/2024</TD><TD>PLANT1</TD><TD>13818.948</TD></TR><TR><TD>240901_IPP.csv</TD><TD>09/01/2024</TD><TD>PLANT1</TD><TD>13782.096</TD></TR><TR><TD>240902_IPP.csv</TD><TD>09/02/2024</TD><TD>PLANT1</TD><TD>13766.628</TD></TR><TR><TD>240903_IPP.csv</TD><TD>09/03/2024</TD><TD>PLANT1</TD><TD>13759.2</TD></TR><TR><TD>240904_IPP.csv</TD><TD>09/04/2024</TD><TD>PLANT1</TD><TD>13788.804</TD></TR><TR><TD>240905_IPP.csv</TD><TD>09/05/2024</TD><TD>PLANT1</TD><TD>13820.676</TD></TR><TR><TD>240906_IPP.csv</TD><TD>09/06/2024</TD><TD>PLANT1</TD><TD>13759.2</TD></TR><TR><TD>240907_IPP.csv</TD><TD>09/07/2024</TD><TD>PLANT1</TD><TD>13824.312</TD></TR><TR><TD>240908_IPP.csv</TD><TD>09/08/2024</TD><TD>PLANT1</TD><TD>13827.816</TD></TR><TR><TD>240909_IPP.csv</TD><TD>09/09/2024</TD><TD>PLANT1</TD><TD>13827.588</TD></TR><TR><TD>240910_IPP.csv</TD><TD>09/10/2024</TD><TD>PLANT1</TD><TD>13793</TD></TR><TR><TD>240911_IPP.csv</TD><TD>09/11/2024</TD><TD>PLANT1</TD><TD>13811.34</TD></TR><TR><TD>240912_IPP.csv</TD><TD>09/12/2024</TD><TD>PLANT1</TD><TD>13797.48</TD></TR><TR><TD>240913_IPP.csv</TD><TD>09/13/2024</TD><TD>PLANT1</TD><TD>12163.92</TD></TR><TR><TD>240914_IPP.csv</TD><TD>09/14/2024</TD><TD>PLANT1</TD><TD>7247.179707</TD></TR><TR><TD>240915_IPP.csv</TD><TD>09/15/2024</TD><TD>PLANT1</TD><TD>7965.06</TD></TR><TR><TD>240916_IPP.csv</TD><TD>09/16/2024</TD><TD>PLANT1</TD><TD>7983.804</TD></TR><TR><TD>240917_IPP.csv</TD><TD>09/17/2024</TD><TD>PLANT1</TD><TD>7977.432</TD></TR><TR><TD>240918_IPP.csv</TD><TD>09/18/2024</TD><TD>PLANT1</TD><TD>7955.76</TD></TR><TR><TD>240919_IPP.csv</TD><TD>09/19/2024</TD><TD>PLANT1</TD><TD>8068.032</TD></TR><TR><TD>240920_IPP.csv</TD><TD>09/20/2024</TD><TD>PLANT1</TD><TD>7964.628</TD></TR><TR><TD>240921_IPP.csv</TD><TD>09/21/2024</TD><TD>PLANT1</TD><TD>7869.156</TD></TR><TR><TD>240922_IPP.csv</TD><TD>09/22/2024</TD><TD>PLANT1</TD><TD>6842.448</TD></TR><TR><TD>240923_IPP.csv</TD><TD>09/23/2024</TD><TD>PLANT1</TD><TD>8127.228</TD></TR><TR><TD>240924_IPP.csv</TD><TD>09/24/2024</TD><TD>PLANT1</TD><TD>8148.468</TD></TR><TR><TD>240925_IPP.csv</TD><TD>09/25/2024</TD><TD>PLANT1</TD><TD>8930.34</TD></TR><TR><TD>240926_IPP.csv</TD><TD>09/26/2024</TD><TD>PLANT1</TD><TD>8996.472</TD></TR><TR><TD>240927_IPP.csv</TD><TD>09/27/2024</TD><TD>PLANT1</TD><TD>10529.904</TD></TR><TR><TD>240928_IPP.csv</TD><TD>09/28/2024</TD><TD>PLANT1</TD><TD>13378.644</TD></TR><TR><TD>240929_IPP.csv</TD><TD>09/29/2024</TD><TD>PLANT1</TD><TD>10730.532</TD></TR><TR><TD>241001_IPP.csv</TD><TD>09/30/2024</TD><TD>PLANT1</TD><TD>7968.408</TD></TR><TR><TD>240801_Ilijan.csv</TD><TD>08/15/2024</TD><TD>PLANT1</TD><TD>13917.48</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The expected visual should be:<BR />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.&nbsp; If I select Aug 7, it will show a bar graph showing 7 bars representing the net generation values from Aug 1 to 7.&nbsp;</P> Mon, 14 Oct 2024 01:40:37 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4240310#M11562 gantaran 2024-10-14T01:40:37Z Re: Month-to-Date Daily Bar Chart https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4241524#M11567 <P>see attached.&nbsp; Not sure if that is a good UX.</P> Mon, 14 Oct 2024 13:52:23 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4241524#M11567 lbendlin 2024-10-14T13:52:23Z Re: Month-to-Date Daily Bar Chart https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4242114#M11571 <P>Thank you so much.&nbsp; This is what I needed.</P> Tue, 15 Oct 2024 01:08:15 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4242114#M11571 gantaran 2024-10-15T01:08:15Z Re: Month-to-Date Daily Bar Chart https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4242661#M11576 <P>Hi, can you also help me with another visual showing YTD daily values?&nbsp; 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.&nbsp;&nbsp;</P> Tue, 15 Oct 2024 07:33:17 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4242661#M11576 gantaran 2024-10-15T07:33:17Z Re: Month-to-Date Daily Bar Chart https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4243392#M11580 <P>&nbsp;</P> <LI-CODE lang="markup">Net Gen YTD = var d = max('Calendar'[Date]) var fd = max('Table'[Date]) return if(format(fd,"mmdd")&lt;=format(d,"mmdd") &amp;&amp; year(fd)=year(d),SUM('Table'[Net Generation]))</LI-CODE> <P>&nbsp;</P> Tue, 15 Oct 2024 15:52:12 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4243392#M11580 lbendlin 2024-10-15T15:52:12Z Re: Month-to-Date Daily Bar Chart https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4244090#M11582 <P>Thanks again!</P> Wed, 16 Oct 2024 05:34:07 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Month-to-Date-Daily-Bar-Chart/m-p/4244090#M11582 gantaran 2024-10-16T05:34:07Z