Dynamically change columns in Matrix

[sugra]

Is it possible to use a matrix (or any other Power BI) option to achieve the following:

I have 3 types of columns - year, yearmonth and week number. The rows and values in the matrix are the same. I want to know if there is a way to provide the user with option to select the column header they would like see at the top of the matrix, so that they can view different informaion in the matrix?

[Anonymous · Accepted solution]

HI @sugra,

I'd like to suggest you take a look at the following blog about dynamic attribute filter if it meets for your requirement:
Dynamic Attributes In A Power BI Report 

Regards,

Xixaoxin Sheng

[Greg_Deckler]

Yes, but you need a very specific dataset layout. See this recent Quick Measure post: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titl...

[sugra]

Hi Greg, 

Thanks. I'll read it. 

Alternatively, is there another way the user can select from a list on one page and the matrix is able to load on another page based on the value selected?