Please find the below links for reference,if it is working then marked as correct or helpful.
Amar D. Savale
The above answer is not correct for my question. If I publish my dashboard or worksheet to tableau server, is there any chance for the user to change the columns or dimensions. For ex: If I have created a dashboard with sales and country, now I want to change the dimension sales to profit, then my dashboard will contain profit and country.
1 of 1 people found this helpful
There are two things -
if you just want users to change the dimension and measure and alter the original after you publish your dashboard Server - Yes it should be simple
They can just edit the dashboard using browser and drag and drop different dimension and measure into view (in this case profit and country) and then just save/overwrite .
Create a Dimension and Measure selector using Paramter .
Create two paramters (Dimension selector and Measure selector)
Your Dimension Selector can contain Dimension like "State"/"Segment"/Category etc.
Your Measure Selector paramter contain things like " Sales"/"Profit"/"Discount"
Create two calculated field some thing similar(below is just an example)
Dynamic Dimension :
IF [Dimension Selector]="State"
elsif Dimension Selector]="Segment"
IF [Dimension Selector]="Sales"
elsif Dimension Selector]="Profit"
Now use these two calculated field in your view instead of real dimension and measure and show the two parameter control
Based on what user select from the selector they will see the dynamic dimension and measure..
Hope this help