Please include a “View” feature in (OAC) DV, similar to the “Bookmark” concept in Power B

Ajinkya Vyawahare

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.