Forum Discussion
sugra
6 years agoHelper I
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...
- Anonymous6 years ago
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
Greg_Deckler
6 years agoCommunity Champion
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
sugra
6 years agoHelper I
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?