Skip to main content

Power BI

Needs Votes

Displaying Measures and Axis Dynamically

Vote (4) Share
Power BI User's profile image

Power BI User on 31 Jan 2020 02:55:13

The idea is to Use Measure Names and Measure Values to set up a quick filter that swaps out the specific measures that are used in the view.

For example, you may have a view showing Sales over time. You have another view showing Profit over time. Instead of maintaining these two on separate sheets, you can create a single view with a quick filter that lets you switch between showing Sales, Profit, and any other measure of interest.

The same brahaviour could be use to create dynamic axis nativelly. Today we need a lot of workround using dax oe even unpivoting tables in the model.

PS - Tableau does that nativelly withouth any workround.

Comments (1)
Power BI User's profile image Profile Picture

Lethabo Tisane on 06 Jul 2020 00:16:09

RE: Displaying Measures and Axis Dynamically

Please can this also be made available when using live data sources