Forum Discussion
Need help in creating Histogram chart in power BI
Hi Guys,
I am new to power BI !!!
I have below data and I want to prepare histogram chart as shown below.
I also like to slice and dice the histogram with filter like week range and segment.
| Order Created Time | Week Range | Dealer | Segment |
| 7/25/2018 15:47 | 07/20/2018 - 07/26/2018 | YC PowerSports Columbia | Powersports |
| 7/23/2018 20:48 | 07/20/2018 - 07/26/2018 | Bright Powersports | Powersports |
| 7/23/2018 15:25 | 07/20/2018 - 07/26/2018 | Bright Powersports | Powersports |
| 7/22/2018 1:44 | 07/20/2018 - 07/26/2018 | YC PowerSports Columbia | Other |
| 7/20/2018 16:41 | 07/20/2018 - 07/26/2018 | Love Motorsports | Boats |
| 7/20/2018 15:24 | 07/20/2018 - 07/26/2018 | Love Motorsports | Boats |
| 7/19/2018 14:54 | 07/13/2018 - 07/19/2018 | YC PowerSports Columbia | Other |
| 7/19/2018 14:54 | 07/13/2018 - 07/19/2018 | Love Motorsports | Boats |
| 7/18/2018 9:56 | 07/13/2018 - 07/19/2018 | Wheels in Motion | Powersports |
Hi senthil9324,
You just need to add a calculate column:
Number of Order Created Modified = SWITCH(Table1[Number of Order Created], 1, "1~2", 2, "1~2", 3, "3~")
Regards,
Jimmy Tao
6 Replies
Hey senthil9324
You easily create a histogram using an R visual. I made a quick video on this here:
https://www.youtube.com/watch?v=nePWIVgHobs
There are also a couple custom visuals for histograms that you can try.
Hope this helps,
Parker
- stuckerj
Helper I
The default R script that runs removes duplicate rows from the data, which defeats the purpose of a histogram. Any suggestions?
v-yuta-msftCommunity Support
Hi senthil9324,
To achieve your requirement, create two calculate columns using DAX below:
Number of Order Created = CALCULATE(COUNT(Table1[Dealer]), ALLEXCEPT(Table1,Table1[Dealer])) Number of Dealer = CALCULATE(DISTINCTCOUNT(Table1[Dealer]), ALLEXCEPT(Table1, Table1[Number of Order Created]))
Then create a stack column chart like this:
Regards,
Jimmy Tao
Hi Jimmy,
Thanks for the reply.
But I want to create histogram bucket wise, like sum of number of dealers falling under 1- 4,5-9,10-19 etc. number of order.
Thanks again.
- v-yuta-msft
Hi senthil9324,
You just need to add a calculate column:
Number of Order Created Modified = SWITCH(Table1[Number of Order Created], 1, "1~2", 2, "1~2", 3, "3~")
Regards,
Jimmy Tao
asitmHelper III
While DAX is a good workaround, it is limited in options- for e.g. changin bin sizes dynamically, using trellis/small multiple, etc.
There are custom visuals on appsource which have these features. The below visual for instance. Though, these are paid visuals and may cost a few dollars per user.
https://appsource.microsoft.com/en-us/product/power-bi-visuals/histogramstd
