Running Total Sort Order with Binned Data (Histogram)

Question

I am attempting to create a histogram via a Stacked Column Chart where I will be able to filter the top N % of values.

So far I have been able to create a table that looks like the following.

This is exactly what I need, with the exception that I need to have the running total order based on the descending count of the [Range] column (the second column shown in the image. Is there an easy way to change the order of the running total column?

Thank you for any help that anyone can provide. I am at a loss of where to proceed from here.

vmonkey · Answer

To aid in understanding my goal, it is to filter out the top n% based on the count, starting with the Mode of the histogram. &nbsp; So instead of this:&nbsp;&nbsp;It would look like this:&nbsp;

vmonkey · Answer

bump ... any experts that could point me in the right direction I can come up with something in Tableau using their color system that is useful but am hoping to use PowerBi for this ...

v-sihou-msft · Answer

vmonkey
&nbsp;
Currently, there's no conditional formatting in chart visuals. You can only put same field in Value into Color saturation. The color will change gradually based on value under same color category.&nbsp;
&nbsp;

&nbsp;
Please vote this idea.
&nbsp;
Regards,

vmonkey · Answer

Hi Simon,&nbsp;Not really what I am looking for - I have a workaround with the color - it is more the capability to sort a binned table based on the count -&nbsp; rather than the bin so I can have a running total based on it.&nbsp; So for example currently the data looks like:&nbsp;&nbsp;[Bin] &nbsp; &nbsp; &nbsp; [Number in Each Bin] &nbsp; &nbsp; &nbsp;&nbsp; [Running Total]&nbsp;1.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;3&nbsp;2.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 17 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;20&nbsp;3.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;25&nbsp;4.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;46&nbsp;5.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 18 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;74&nbsp;&nbsp;What I would like instead is to have the running total quick measure be based off of the "[Number in Each Bin]" instead of the "[Bin]" starting in a decending order&nbsp;[Bin] &nbsp; &nbsp; &nbsp; [Number in Each Bin] &nbsp; &nbsp; &nbsp;&nbsp; [Running Total]&nbsp;4.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;21&nbsp;5.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 18 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;39&nbsp;2.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 17 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;58&nbsp;3.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;63&nbsp;1.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 66&nbsp;&nbsp;If I could do that, I would be able to get the result that I need,&nbsp;

vmonkey · Answer

bump?

Forum Discussion

Running Total Sort Order with Binned Data (Histogram)

5 Replies

Related content

Histogram with Dynamic Bins

Age Bins

Histogram with dynamic bins

Histogram - User defined bin size

Histogram custom bins