Hi everyone,
I am trying to create a table in Tableau (see attached screenshot). Under a single Category column, I need to display two different number formats for the metrics:
- One metric as a percentage
- Another as an absolute value
I have more than 60 metrics, and when I split the columns across multiple worksheets and place them in a dashboard, each sheet shows its own scrollbar, which makes the dashboard difficult to use.
Is there a way to:
- Display multiple metrics with different number formats under the same category, and
- Avoid having scrollbars on every worksheet, while still showing all metrics in a single, clean table layout?
Any help would be appreciated.
#Tableau Desktop & Web Authoring #Tableau
3 answers
I have a blog post about pivoting the measures here: https://bi-stories.blog/2025/08/11/the-measures-pivot/
Dan ChissickSenior BI Consultant | Tableau Ambassador