histogram problem in displaying the frequencies in percentage

[MAAbdullah47]

Dear Ladies/Gentleman

I have a histogram display the range of order total sales per order here is an example:

Assume the total number of orders is 600,000 and the total sales is 40,000,000 $, the histogram will

display the sales distribution according to the following sequence:

sales range               order frequency

-----------                 ----------------

sales (0-10) $ ----> 100,000 orders out of 600,000

sales (10-20) $ ---> 97,564 orders out of 600,000

......etc

If I want to display the Histogram as frequency with show value as (no calculation) the histogram display the order frequency as above example ,   But If I want to display show value as (percent of grand total) it displays the frequencies equally 10 for each sale range (not right), anyone tell me how to solve this problem to display the frequency in percentage?

Frequencies No calculation (OK)

[v-jiascu-msft]

@MAAbdullah47

Hi,

You must be using custom visual “Histogram”. It looks great. Maybe you used a wrong visual in your scenario. Frequency in “Histogram” usually count the frequency of “Values” in the visual. For example, frequency of “1-5” is 4 which counts the Sales, not the sum of “Whatever”.  Reference here: https://en.wikipedia.org/wiki/Histogram

Sales    Whatever
1           122
1           169
3           187
4           196
6           177
6           136
7           141
12         120

May be you need a Clustered Column Chart. Using bins to categorize the “Sales”.  (Click New Group to create bins.)

Best Regards!

Dale

[MAAbdullah47]

Any Comment please about My last replay? 

[v-jiascu-msft]

@MAAbdullah47

Hi,

If you used the Clustered Column Chart, you don't need to add legend. In the "axis", it should be "sales range" (in your first post). The value should be "order frequency" (show value as percentage of grand total).  If your source data looked like this, it should be grouped.

sales range  order frequency

0                   10000

1                   10000

2                   10000

Grouping isn't needed in this scenario.

sales range  order frequency

0 - 10                    10000

11 - 20                  10000

21 - 30                  10000

Please have a try.

Best Regards!

Dale

[MAAbdullah47]

It looks better than before, But Still, each number alone how I do it like what you said in the second part of your previous post ?

[MAAbdullah47]

It looks now better than before.

What you said in our last post is:

sales range  order frequency

0 - 10                    10000

11 - 20                  10000

21 - 30                  10000

How can I do it on sales range?

[MAAbdullah47]

I mean in the tool tip how I can display it as sales range (0-10) (10-20) ,,,etc ?

[v-jiascu-msft]

@MAAbdullah47

Hi,

You don't need to add it. The visual will show the axis. Have a look at the picture. In the last scenario, no group needed.

Best Regards!

Dale

[MAAbdullah47]

Still, I'm not able to do it as label ranges !!

[v-jiascu-msft]

@MAAbdullah47

Hi,

You used bins. Maybe you can use this measure. (Make any changes necessary). And then add it to Tooltips.

Measure =
CONCATENATE (
    CONCATENATE ( MIN ( 'Table1'[Total sales] ), "-" ),
    MAX ( 'Table1'[Total sales] )
)

Best Regards!

Dale

[MAAbdullah47]

Not Accept Measure when I put it in the (Axies)

[v-jiascu-msft · Accepted solution]

@MAAbdullah47

Hi,

Add to the Tooltips, not the axis. Try it please.

Best Regards!

Dale

[MAAbdullah47]

Thank You So much It works now, sorry that it takes much time but at the end, we achieve what we want.

[MAAbdullah47]

Still Not Working Can You explain how I do it appears in the Graph again step by step?

[MAAbdullah47]

I did it In groups but It doesn't look nice. I don't know how to deal with it do you have reference or tutorial do it step by step?

[MAAbdullah47]

But Now Become worse , It does not group them in ranges (0-10) ,(10-20) ,,,,etc

[MAAbdullah47]

[MAAbdullah47]

No Updates?