Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to do Store Busy time Analysis

i have transaction time entered to my db whenever customer closes a deal.  how can i use the time information to analyze the busy time and busy day reports ? for example i want to know what time du...
Need Help
Show and Tell
  • lc_finance's avatar
    lc_finance
    6 years ago

    Hi Anonymous ,

     

     

    What about the heat streams chart which you can find in the marketplace?

    In my example below I use it to chart sales count based on day and month.

     

    Regards

     

    LC

     

    Here is my visualization:

  • Anonymous's avatar
    Anonymous
    6 years ago

    Above solution is good. but after extensive search i found a better solution.

     

    We will have to use D3.js custom visual.

     

    to use the D3 i qoute from the article titled "How to render D3.js custom charts in Power BI Desktop"

    source https://www.mssqltips.com/sqlservertip/5273/how-to-render-d3js-custom-charts-in-power-bi-desktop/

     

    "One needs to know D3 programming to develop custom visualizations. In this tip, the intention is to just take the D3.js code and port it to Power BI Desktop to render the visualization. So, we will be focusing on sample D3.js code and will understand how to use this in Power BI Desktop."

     

    there's a gallery on github with D3 custom visuals https://github.com/d3/d3/wiki/Gallery

     

    from this gallery i used Day / Hour Heatmap for Tom May. here is a screenshot.

     

    check the tutorial here. https://www.mssqltips.com/sqlservertip/5273/how-to-render-d3js-custom-charts-in-power-bi-desktop/

    Thanks for supporting me

     

    d

Anonymous's avatar
Anonymous
Not applicable
6 years ago

This is a good visual indeed. Thank you for suggesting.

 

How can i change the size of the month name, also sort the month starting from Jan to Devember. 

 

is there any other visual you suggest besides this?

 

Appreciate your help

lc_finance's avatar
lc_finance
Solution Sage
6 years ago

You are right, this visual orders the months in alphabetical order, even if it does not make sense..

You can create a new column 'Month number' with the month as a 2 digits numbers. You put the formula below for you. It's less nice than having the month written down but it works.

 

I could not find any other visualization for this.

 

Regards,

 

LC

 

 

 

Month number = FORMAT(month([date]),"00")

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Above solution is good. but after extensive search i found a better solution.

     

    We will have to use D3.js custom visual.

     

    to use the D3 i qoute from the article titled "How to render D3.js custom charts in Power BI Desktop"

    source https://www.mssqltips.com/sqlservertip/5273/how-to-render-d3js-custom-charts-in-power-bi-desktop/

     

    "One needs to know D3 programming to develop custom visualizations. In this tip, the intention is to just take the D3.js code and port it to Power BI Desktop to render the visualization. So, we will be focusing on sample D3.js code and will understand how to use this in Power BI Desktop."

     

    there's a gallery on github with D3 custom visuals https://github.com/d3/d3/wiki/Gallery

     

    from this gallery i used Day / Hour Heatmap for Tom May. here is a screenshot.

     

    check the tutorial here. https://www.mssqltips.com/sqlservertip/5273/how-to-render-d3js-custom-charts-in-power-bi-desktop/

    Thanks for supporting me

     

    d

    • lc_finance's avatar
      lc_finance
      Solution Sage
      6 years ago

      Hi Anonymous ,

       

       

      I am glad you found an even better solution. 

      The D3js charts look good.

       

      Do not hesitate if you have more questions,

       

      LC