Do I have the ability to create filters for stakeholders to select specific measure names they want to view instead of displaying all of them as columns? Similarly, can I implement a filter for columns like ‘MP’ if they wish to view something else, such as ‘Devices’? Is this feasible or possible?
Thank you!!
Hi @Phillip_Le,
You can create some generic calculated fields like Measure1, Measure2, Measure3. etc. Create parameters and add them to each calculated field like this:
Measure 1:
ifelse(${Parameter1} = 'Sales', {Sales}, ${Parameter2} = 'Profit', {Profit}, {Cost})
Add the calculated fields as columns in your table and create controls for your parameters. When the user selects ‘Sales’ in your control, the Measure1 column in your table will show Sales. You can also use the parameter value as your column header. Repeat for all other columns.
It’s probably not what you had in mind but that’s the only workaround I can think of.
Can Measure1 name changed in the header depending what is clicked; Sales is clicked then Measure1 name changes to Sales in the header or Profit is clicked then the header changes to Profit?
Yes, you can use ${Parameter1} as the column header to do that.
Thank you sir! Everything works
@David_Wong Is there a way to have an “all” option where the users clicks all and all the metrics are shown on the page?
I’m not sure I understand your question. Since each column in your table visual shows one metric, your parameters have to be single-valued and it wouldn’t make sense to allow the user to select “All” for one parameter. Each parameter should also have a default value so that every column shows one metric by default.
@David_Wong Got it. If I have several different metrics, is there a way to designate certain ones as a percentage or currency?