Eugene on 18 Jan 2017 04:09:53
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.
- Comments (4)
RE: Dynamic Variable/Parameter (Tableau feature)
Tableau allow creation of unlimited variable of any sort. Basic idea guys!!!!
RE: Dynamic Variable/Parameter (Tableau feature)
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
RE: Dynamic Variable/Parameter (Tableau feature)
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!
RE: Dynamic Variable/Parameter (Tableau feature)
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"