Dynamic dimension selection based on slicer
We should able to use same report to show measure by multiple dimension. Dimension should be selected based on slicer. If user select Product name from Slicer, Sales should be displayed based on Product name, If user select Country from slicer, Sales should be displayed based on Country
Dynamically set formatting for dynamic measures
Currently we can use same report to visualize multiple measures by adding new table with all the measure names and creating calculated measure using switch statement to display selected measure. However, if we want to display measure of different types for e.g. Currency/Percentage/Decimal, there ...