Having some variable element which works as a place holder or switch to activate different measures based on a selection made. Example: I have a plot for this switch variable over time. With a slicer or drop down selection that variable can take the values of Sales when "Sales" is selected, profit when "Profit" is selected", inventory... This is also useful for adjusting legends and other categorical breakouts to gain insights into data quick and visually.
5 Comments
- Having dynamic variable names based on formulas would help my organization. Example: I use formulas for sales in the last "x" years. Instead of being able to name "2015 Sales" I have to name it "Sales 2 Years Ago", which is clunky and forces the end-user to convert my name into a year. Solution: Variable Name as: =year(today () )-2 & " Sales"
- This would be great to have for dynamic dimensions as well. Measures seem to be a lot more efficient to work with. Having something where creating dynamic dimensions would be really helpful!
- Here is a short note on how to create dynamic parameter in PowerBI: http://www.dabis.solutions/2017/12/how-to-create-dynamic-parameter-in.html
- Tableau allow creation of unlimited variable of any sort. Basic idea guys!!!!
- Status added:Needs Votes
