In one scenario, a user requested to display both Net Sales and Sales Growth within the same report. To accommodate this, I created a parameter with “$” and “%” as selectable values. I then developed a new calculated measure using a CASE WHEN statement to dynamically switch between Net Sales and Sales Growth based on the user’s selection.
However, this approach has introduced a challenge with formatting. Specifically, it prevents me from applying distinct formatting rules to each metric. Ideally, when the user selects “$”, the Net Sales values should be formatted as “523M”. Conversely, when “%” is selected, the Sales Growth values should be formatted as “5.23%”. Since both metrics are now represented by the same measure column, I am unable to set dynamic formatting that adjusts based on the selected value.
This limitation is obstructing our ability to present the data in a clear and user-friendly manner, as the formatting does not dynamically adjust to reflect the nature of the selected metric.
