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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
nkhalqi
New Member

Need way to measure/filter with multiple values in multiple columns

I have a data set of about 100 companies that I would like to analyze on Power Bi. Within the data set columns, there are multiple multi-value columns.

 

For example a company is headquartered in NY but operates in 20 states across the US. The same company also serves multiple geographic reigons (rural, native colonies, city-wide, etc). The company as a whole has a total asset of 10 million.

 

 

For accurate visulaization, what do I need to do to be able to map all the operating states (it would be great if I can add a pin for where it is headquartered which is a seperate column), and have the company show up whenever any of the multi-values is picked. If I split these columns, should I do split to rows or columns? & if I split, won't the values such as the financial information be counted multiple times?

1 REPLY 1
Greg_Deckler
Super User
Super User

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.

 

Specifically, sample data.



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!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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