Forum Discussion
Create Measure from column values then Extract
SammiF1244 , As long as original columns are present in the table, you can use them in visual. You can create the using switch in a measure
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
amitchandak Thank you for your reply. My issue is the label of the visual only includes the final detaIls:
and I want the 'MODIFY' value (label) to show the parenthetical version from earlier in my steps that I can only see on the 'Transform data" screen:
Early in the applied steps: (this is what I want for the 'visual' - so I was thinking a measure but can't figure out how to grab the values this early in the transforms steps as it only 'sees' the final output)
Current Situation:
The current label for the visual only reflects the final details after all applied steps under transform:
(this is what I need for the final 'output')
Desired Change:
I'd like to use the value (label) to include the parenthetical information initially presented earlier in the applied steps. This information is currently only visible on the "Transform data" screen when clicking on a step before the extract step:
Explanation:
The additional text in parentheses, "(Desired text)," represents the specific details I want to display from the earlier transformation stage. This information adds essential context to the final data displayed in the visual for dahsboard users, but needs to be excluded in 'table' data.
Technical Considerations:
While I understand that the "Transform data" screen showcases intermediate values not reflected in the final output, I'm exploring the possibility of using a calculated field or measure to access these earlier values and incorporate them into the label. However, I'm unsure of the feasibility of this approach. Perhaps there's an alternative approach I haven't considered??
Thank you for your continued assistance. Please let me know if you need further clarification or if you have any questions.