Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi,
Add to the Tooltips, not the axis. Try it please.
Best Regards!
Dale
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
Any Comment please about My last replay?
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
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 ?
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?
I mean in the tool tip how I can display it as sales range (0-10) (10-20) ,,,etc ?
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
Still, I'm not able to do it as label ranges !!
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
Not Accept Measure when I put it in the (Axies)
Hi,
Add to the Tooltips, not the axis. Try it please.
Best Regards!
Dale
Thank You So much It works now, sorry that it takes much time but at the end, we achieve what we want.
Still Not Working Can You explain how I do it appears in the Graph again step by step?
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?
But Now Become worse , It does not group them in ranges (0-10) ,(10-20) ,,,,etc
No Updates?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |