Dynamically Selecting Measure & Dimension values in the View.1) Create a Parameter for Dimension Selection purpose "Dimension Parameter", By using this Parameter, we can select the Dimension Value (Field) dynamically.
2) Create a Parameter for Measure Selection purpose "Measure Parameter", By using this Parameter, we can select theMeasure Value (Field) dynamically.
3) Create a Calculated Field for Dimension Selection using the syntax in the image.
4) Create another calculated field for Measure Selection like below image.
3) Place "Measure Selection", "Dimension Selection" calculated fields, Right click on both Parameters & Click on "Show Parameter Control". (Note: We can select Max 1 Value at a time from any parameter, It means Parameter limitation is Select Max 1 Value at a time.)
1 of 1 people found this helpful
There is no option added single dimension at present.
Better want to see single dim data then use in quick filter and see dim values.
vote this into ideas.
I thought this facility is useful as user can quickly see what kind of data is in store (and as it is limited to one column, identification is easy and response will be faster).
As you suggested, i will post it in ideas.
I want to select multiple dimension. How to do this because in parameter we can select only one value at a time?
Up to Version 8.2 In Tableau, Parameter supposts Single selection.
So we have to use multiple Paramaters to add either Dimensions or Measures to the View.
My previous post of this thread will help you that.
One more thing, We can add multiple Measure to the report using "Measure Names, Measure Values'.
The following link will help you to place multiple Measures to the report.
(This link is having different requirement but it will help you once you right click on "Measure Names" select "Show Quick Filters".
My requirement is I want to display multiple dimensions on the view dynamically. Multiple measure is selected through measure name filter but how we do apply same logic on dimensions. Suppose, I have 10 dimensions and user wants to select 5 dimensions on the run time. How we do this?
As of now, We dont have that option.
So, Create 5 Paramaters for Dimension selection then create calcuulations accordingly then add to the report.