Forum Discussion

vmonkey's avatar
vmonkey
Helper I
9 years ago

Running Total Sort Order with Binned Data (Histogram)

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.   ...
vmonkey's avatar
vmonkey
Helper I
9 years ago

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's avatar
v-sihou-msft
Microsoft Employee
8 years ago

vmonkey

 

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. 

 

 

Please vote this idea.

 

Regards,

  • vmonkey's avatar
    vmonkey
    Helper I
    8 years ago

    Hi Simon,

     

    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 -  rather than the bin so I can have a running total based on it.  So for example currently the data looks like:

     

     

    [Bin]       [Number in Each Bin]        [Running Total]

     1.00                       3                                 3

     2.00                       17                               20

     3.00                       5                                 25

     4.00                       21                               46

     5.00                       18                               74

     

     

    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

     

    [Bin]       [Number in Each Bin]        [Running Total]
     4.00                       21                               21
     5.00                       18                               39
     2.00                       17                               58
     3.00                       5                                 63
     1.00                       3                                 66 

     

    If I could do that, I would be able to get the result that I need,

     

    • vmonkey's avatar
      vmonkey
      Helper I
      8 years ago

      bump?