cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Hiding columns in a matrix based on a filter

I have a table with the following columns

 

Region

Category

Org_comment

Region_comment

Cat_comment

Eff_month

Variance_amt

 

I have a filter where the user selects the type of comment to display : Org / Region / Cat

 

I need to display the following in a matrix: ( The comment column should show either org_comment, region_comment or Cat_comment based on user selection)

Region Category and Comment are the rows

 Eff_Month is the column and

Variance_amt is the value

 

RegionCategoryCommentEff Month
    
    

 

Thanks for your help.

 

Raymond

3 REPLIES 3
Highlighted
Super User IX
Super User IX

Re: Hiding columns in a matrix based on a filter

@Raymo3u99 , see if that can help

https://www.youtube.com/watch?v=6jeSIRpjv0M



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper I
Helper I

Re: Hiding columns in a matrix based on a filter

Thanks @amitchandak .

That worked for me. The only issue I found was that it dropped null values from the unpivoted column, so I had to create a view and replace nulls with blanks.

 

Highlighted
Community Support
Community Support

Re: Hiding columns in a matrix based on a filter

Hi @Raymo3u99 ,

 

"That worked for me. The only issue I found was that it dropped null values from the unpivoted column, so I had to create a view and replace nulls with blanks."

Please show a sample data table, maybe I can help you complete the table conversion work.

 

Best regards,
Lionel Chen

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors