Dollar Ranges

[Anonymous]

So I'm not sure if this is possible, but is there any way to make a column be dynamic?? What I know my users are looking for is the ability to set date ranges themselves and have people categorized based on the date range they've selected. So below this is looking at a date range of 4/16/18-4/16/19:

So the measure 'Beg Revenue' calculates dynamically based on the date range selected. So looking at the highlighted row, we see the revenue is ~$29,000, but the '$ Range' column is returning a range of $50,001+ which isn't correct. It's not correct because the company by default is being categorized based on the TOTAL amount of revenue it has in the revenue table and not what the company made between 4/16/18-4/16/19. 

This is tricky to pull off because I was aiming to build something like this:

  

So the highlighted company in the first screenshot would be placed in the far right column when it should be placed in the 15,001-50,000 column.

I know I can build this column into a measure that does calculate dynamically, but I know measures cannot be placed on a matrix like this for viewing, so I feel stuck. Any suggestions?

[v-yuta-msft]

@Anonymous ,

I'm afraid power bi doesn't support dynamic calculate column as you required. You need to use a measure instead, you can drag the measure to values field of the matrix visual.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-yuta-msft Is it possible to create a column based on the sum of revenue they made in a particular year? Like pulling in a few years of revenue, but placing them into categories based on the amount of revenue they made in 2018. All companies make roughly the same amount of money each year, so I'm sure that would suffice. Currently the ranges are being decided based on all revenue from the past few years. So if from 2016-Today a company made a total of $70,000 the table is placing them in the $50,001+ category which isn't what I want. If I could figure out how to bucket them into a single year of revenue, that would work.