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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Vatz8
Helper I
Helper I

Create a Category column that assigns categories to the measure selected in a Matrix

Hi,

I have a matrix which has multiple measures as values. I want to create a column which assigns categories for the measures. So for example I have 10 measures named Measure 1 to Measure 10. All 10 measure are already placed in the matrix. I want to create a column which assigns these measure some categories. Like Measure 1 to Measure 4 should have "Category A", Measure 5 to Measure 7 should have "Category B" and Measure 8 to Measure 10 should have "Category C".
This should appear as column next to the Measure names in Matrix. Please note that the measure belong to different tables but are in a single Matrix Visual.

So in essence there should be a category name next to each Measure name or even a common name if a bunch of measure from same categories are selected back to back. Either way.

1 REPLY 1
Anonymous
Not applicable

Hi @Vatz8 

 

Power BI's matrix visual primarily aggregates data and doesn't natively support the direct categorization of measures within the visual itself. You can try looking for custom visuals to see if they meet your needs.

 

 

 

Best Regards,

Jayleny

 

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.