I want to be able to create a control that toggles between % and absolute value of the pivot table. The user can select ‘%’ to see all the data as a % or $ to see all the data in its raw form or absolute value form.
Hi @Entrepreneurldz
you could try to use a calculated field (“measure to display”) that displays one or the other measure based on the control. you also should define the default format for both measures. I’m not 100% sure the format option will work.
You also could manage the column label with the parameter.
BR
Hello, I got it to work where I can show % and $. However, when I do %, it does across the row as a default. I want the % to be based on table down or column. Would you know how to do this via a calculated field?
Sadly that’s what a expected and thinks that’s not possible so far.
Would it be an option to label the column as “in $” and “in %” and don’t show the signs within the cell?