Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sugra
Helper I
Helper 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. 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?

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Greg_Deckler
Super User
Super User

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...


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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? 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.