Forum Discussion
Dynamically change columns in Matrix
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?
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 ReportRegards,
Xixaoxin Sheng
3 Replies
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 ReportRegards,
Xixaoxin Sheng
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-titles-chart-types/td-p/1027881
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?
