https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-can-I-create-a-line-chart-of-sales-from-7-am-to-7-am/m-p/3862454#M9508 <P>Hi everyone,<BR />this is my first time in this forum.<BR />I am doing my internship on a concerthall where I have been asked to create a dashboard that shows the key metrics of the F&amp;B team. Currently I am trying to create a visual of the sales per concert, after analyzing the sales of a concert I noticed that people still buy drinks after 12 am but in the visual the time runs from 12 am to 11:59 pm. I am currently looking to create one that starts from 7 am to 6:59 am (since the venue can have concerts from 8 pm to 2 pm but also events from 10 am to 4 pm). I tried already creating a time table starting from 7 am, also making new measures but unfortunalely I haven't had luck. Could someone explain me step by step what I should do in this situation, I am really lost.</P><P>If there is anything else that I need to provide do not doubt to contact me.</P><P>Thanks in advance!<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nandulila_0-1713877897133.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1084409i9BA6105C22D310C7/image-size/medium?v=v2&amp;px=400" role="button" title="nandulila_0-1713877897133.png" alt="nandulila_0-1713877897133.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nandulila_1-1713877967729.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1084410iFFB8D64C31A978D8/image-size/medium?v=v2&amp;px=400" role="button" title="nandulila_1-1713877967729.png" alt="nandulila_1-1713877967729.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nandulila_2-1713878066215.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1084413i68C5A420867ABBD6/image-size/medium?v=v2&amp;px=400" role="button" title="nandulila_2-1713878066215.png" alt="nandulila_2-1713878066215.png" /></span></P><P>&nbsp;</P> Tue, 23 Apr 2024 13:20:36 GMT nandulila 2024-04-23T13:20:36Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-can-I-create-a-line-chart-of-sales-from-7-am-to-7-am/m-p/3862454#M9508 <P>Hi everyone,<BR />this is my first time in this forum.<BR />I am doing my internship on a concerthall where I have been asked to create a dashboard that shows the key metrics of the F&amp;B team. Currently I am trying to create a visual of the sales per concert, after analyzing the sales of a concert I noticed that people still buy drinks after 12 am but in the visual the time runs from 12 am to 11:59 pm. I am currently looking to create one that starts from 7 am to 6:59 am (since the venue can have concerts from 8 pm to 2 pm but also events from 10 am to 4 pm). I tried already creating a time table starting from 7 am, also making new measures but unfortunalely I haven't had luck. Could someone explain me step by step what I should do in this situation, I am really lost.</P><P>If there is anything else that I need to provide do not doubt to contact me.</P><P>Thanks in advance!<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nandulila_0-1713877897133.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1084409i9BA6105C22D310C7/image-size/medium?v=v2&amp;px=400" role="button" title="nandulila_0-1713877897133.png" alt="nandulila_0-1713877897133.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nandulila_1-1713877967729.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1084410iFFB8D64C31A978D8/image-size/medium?v=v2&amp;px=400" role="button" title="nandulila_1-1713877967729.png" alt="nandulila_1-1713877967729.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nandulila_2-1713878066215.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1084413i68C5A420867ABBD6/image-size/medium?v=v2&amp;px=400" role="button" title="nandulila_2-1713878066215.png" alt="nandulila_2-1713878066215.png" /></span></P><P>&nbsp;</P> Tue, 23 Apr 2024 13:20:36 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-can-I-create-a-line-chart-of-sales-from-7-am-to-7-am/m-p/3862454#M9508 nandulila 2024-04-23T13:20:36Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-can-I-create-a-line-chart-of-sales-from-7-am-to-7-am/m-p/3863689#M9513 <P>Read about how to sort a column by another column. Add a sort column that is shifted by 7 hours and then sort your hour column by that new column. You'll need to add the column further upstream to avoid circular dependencies.</P> Wed, 24 Apr 2024 00:15:28 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-can-I-create-a-line-chart-of-sales-from-7-am-to-7-am/m-p/3863689#M9513 lbendlin 2024-04-24T00:15:28Z