Forum Discussion

TheBIGuy_PBI's avatar
TheBIGuy_PBI
Helper II
3 years ago
Solved

Using How-to-display-different-measures-using-a-selector

Hi, I found this article very interesting
Solved: How to display different measures using a selector - Microsoft Power BI Community

I currently have a table that shows Autos and current sales, last years sales and % Diff.

My column is year-month, and my row is AutoManufacturer - but can be jet manufacturer, computer manufacturer, etc.

The link above describes how to change measures but how do you go about changing rows if they're from different tables? The link above perfectly describes how to change measures based off of a drop down, but what about changing the row or even the column on the fly, depending on what the user chooses?

Now i would like to change the rows in my matrix from one dimension to another, while keeping the measures as is