Forum Discussion

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 during the day we closed most deals?

I am looking for a result like the following:

the following is the table i have in my data model. Along with store name and location where the transaction took place.

Besides, i want to do it on a line chart for the same.

is there a visual that will help?

regards

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

5 Replies

lc_finance
Solution Sage
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
  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
    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")

Related content