cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RainyDays
Regular Visitor

Matix with dynamic rows, column and value selection

Please help on this:

I have a table (data source) with columns:

C1, C2, C3, C4, M1, M2, M3 etc.

Now I have to create a matrix where users can choose using a slicer what goes in rows or colum or value. Say:

 

 C2
C1M1

 

or

 

 C1
C3M2
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Matix with dynamic rows, column and value selection

Hi @RainyDays ,

For swithching columns in Matrix, you could reference the links to have a try.

dynamic column selection.gif

Reference:

https://community.powerbi.com/t5/Desktop/Dynamic-column-selection-for-matrix-visual/td-p/687993

Power BI - Dynamic Columns in a Table 

 

Currently, it is not supported to drag measures into Row field. So we can't change them directly. You could reference the blog to use Bookmarks or pivot table to have a try.

4 different ways to dynamically change table’s rows in Power BI 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
HashamNiaz Helper I
Helper I

Re: Matix with dynamic rows, column and value selection

Hi !

Seems like you are trying to complicate the things, Power BI is a self service tool, just connect the PBI Desktop file with your data model & let user drag & drop columns into rows & columns.

Nothing to worry about, only expose selected columns.

Regards,

RainyDays
Regular Visitor

Re: Matix with dynamic rows, column and value selection

I have to finally publish this report to Power BI online. Users are not using desktop version....also this is part of a migration project from Tableau so my goal is not to take away any functionality they used to have in Tableau.

Community Support
Community Support

Re: Matix with dynamic rows, column and value selection

Hi @RainyDays ,

For swithching columns in Matrix, you could reference the links to have a try.

dynamic column selection.gif

Reference:

https://community.powerbi.com/t5/Desktop/Dynamic-column-selection-for-matrix-visual/td-p/687993

Power BI - Dynamic Columns in a Table 

 

Currently, it is not supported to drag measures into Row field. So we can't change them directly. You could reference the blog to use Bookmarks or pivot table to have a try.

4 different ways to dynamically change table’s rows in Power BI 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Community Support
Community Support

Re: Matix with dynamic rows, column and value selection

Hi @RainyDays ,

Is the answer helpful? If yes, please accept it as a solution. Then others who have the same requirement will benefit from this thread.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors