Forum Discussion
Creating Dynamic Revenue Range
Hi Anonymous,
Sorry for the delay.
If I understand your scenario correctly that you want to create a date slicer and a range slicer to filter the companys which belongs to the range during the period.
It seems that you want to calculate the dynamic Revenue, that should be a measure.
However, as we know that we cannot use measure as the slicer. So I'm afraid we cannot create the Dynamic Revenue Range to achieve your requirement.:smileysad:
Best Regards,
Cherry
Community ChampionHi Anonymous
It would help if you post the code and data in text format so that it can be readily copied or otherwise share the pbix.
Check this out. It might come in handy
AlB my pbix file is connected to our SQL database :smileysad: I will try to keep it simpler by looking at 1 company. So on my revenue table is this:
So this company from May 2014 - Today has generated a grand total of $25,203.43. So if I were to bucket this company into one of the category ranges, it would obviously be in the $20,000+ range.
Now let's say I want to see how much money this company made from May 2016-Today. That would look like this:
So now the total is $15,996.45. So now when looking at this, I would want this company to now be bucketed in the $10,000-$20,000 range since that is what they made between May 2016-Today. Is making a measure like this possible? I have my revenue table connected through a date table through an inactive relationship (Invoice Date->Date) :
So if a user selects a time period of one year (Date table used as slicer) for instance, and let's say they choose the $10,000-$20,000 range. They would be looking at all companies in that one year period that had a total revenue of $10,000-$20,000, despite if their overall grand total (ignoring all dates) is over $20,000.