I'm trying to create a worksheet using all measure values and then selecting the one I want as a bar or line chart. Since I'm using all measure values, some are numeric and others are percentages.
What I like to have is a way to automatically change the row header so that it matches the value type being shown: if I'm showing numbers, it will show numbers; if I'm showing percentages, it will show percentage.
Is this possible, and if so, how is this achieved? Thanks in advance for any response; it's appreciated.
Regards,
Gil
Khyati Mehta (InfinySkills) 
Forum Ambassador
Hello Gil,
Unfortunately, no, Tableau doesn't dynamically change the number format of the row header based on the selected measure when you're using Measure Values and Measure Names together.
The row header formatting is applied at the worksheet level, so if you have a mix of numeric measures and percentage measures, Tableau will generally use a single format unless you manually handle it.
A few workarounds you can try:
- Use parameter-based measure selection instead of Measure Values. Create a parameter to choose the measure and then use a calculated field with separate formatting for each measure.
- Create separate sheets for percentage and numeric metrics and swap between them using a parameter or dashboard actions.
- If the values are only being displayed as labels you can use a formatted string calculation, though this won't change the actual axis formatting.
So, out of the box, there isn't an automatic way for the row header to switch between number and percentage formats when using all Measure Values in a single worksheet. A parameter-driven approach is usually the cleanest workaround. Hope this helps!
