Forum Discussion
How to create a dashboard with moving variables?
its similar in concept to a segmentation tool I created for suppliers who would get scored on various attributes that could be flexed during the year or for what was strategically important at the time.
The solution I came up with, was to have a table for each of the variables with in my case the weightings of importance but in your case it will be some other type of metric. The tables for each attribute I made were a simple GENERATESERIES(start,end,increment) then for each table I made a measure with SELECTEDVALUE() so that when the tables were filtered in the filter pane (make sure its set to single select) it would flex the measure.
My only gripe was that, I couldnt cascade the GENERATESERIES() start or end values to be cut off by the SELECTEDVALUE() of a previous attribute. This meant I did need a tile to show if the total of the SELECTEDVALUE()'s was not equal to my weighting total.
The end result is a tool where we can easily assign values on the fly to segmentation which I suspect is what you are wanting to do.