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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Regular Visitor

Counting Text across multiple columns

I'm pretty new to Power Bi - I have a data set that contains multiple strengths (ie strength 1, strength 2, strength 3 etc) along with other columns (name, function, etc). The strengths are from a set list of 34 possible words - I'm trying to create a visual to see the count of each word across all strength columns. Is that possible? Does this even make sense - in excel I would use the COUNTIF function and link it back to the strength and create a new table - but I'm struggling with doing the same in Power Bi

Super User
Super User

@AA364 , One is you can unpivot all the columns in power query and then you will all strength in rows with their name


Another join a strength dimension to all strength columns, You will have 1 active and the rest inactive join. Use userelationship to create count measures

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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


Power BI Monthly Update - May 2024

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