Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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?
Solved! Go to 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
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
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...
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?