I’ve got a calculated field returning a string and have a parameter for it. In the value names it lets me use the parameter and it changes the column heading, but it gives me the value “All” which is not correct. I want it to return the value I placed in the string in the calculated field.

Are you changing the parameter? It will only change when you change the parameter. You can do that with a control. You cannot change the parameter with a calculated field.

I have the parameter pointed to a column of data with the value I want to display. All of the rows have the same value which kind of explains the All, but that is not what I want. My goal is have the column header by something like Jan 2022 Feb 20222 The dynamic date option doesn’t work, becaus…

I’m sorry, so you’re saying something like this won’t work because you don’t have all of the dates in your dataset? [image]

The date as a pivot column, as you suggest is a great idea that I tried. However, I get stuck on calculating the change from the prior month & percentage change from prior month. – PriorMonth as calculated field sum(if else(dateDiff(MyPivotDate,AsOfDate,“MM”) = 1, 0) /* comes up with zeros whic…

Dynamic column names not working - returns "All"

Q&A

Kellie_Burton January 24, 2023, 2:50pm 6

Hi @Steve1!
Here is an article on the Community that shows examples of how to calculate current period, previous period and percent difference.

Topic		Replies	Views
Dynamic column names Q&A parameters , quick-sight	4	3864	April 1, 2025
Dynamic Headers Q&A parameters , quick-sight , Business-Intelligence-Engineer , tables	1	271	March 7, 2024
Dynamic Column Names based on calculations Q&A formatting , feature-request , quick-sight	3	1417	August 17, 2023
Dynamic Parameter value based based on value of another parameter Q&A parameters , feature-request , quick-sight , filters-controls-and-parameters , Business-Intelligence-Engineer	4	173	December 27, 2024
Replacing the row names on a pivot table to be show quarters(Q1, Q2, Q3 and Q4) which can be changed dynamically using a control Q&A analysis , filters , parameters , formatting , quick-sight , calculations	6	1095	September 7, 2023

Dynamic column names not working - returns "All"

Related topics