Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I have a variable/column ('CountryActivity') where repondents had to indicate in which countries they are active. Now most of them are active in multiple countries and 'CountryActivity' now figures multiple countries delimited by a semicolon.
I want to be able to create a slicer for a visulaized table with the respondents names (companies) that filters for the single country activity (being able to choose Canada and then seeing the companies that contain Canada in the 'CountryActivity' coumn). When I use 'CountryActivity' I off course only get wild country mixes as options to choose from to filter my table output.
I tried working with parameters and setting up a table with the single country names as filter but couldn't get to a solution. How would you go about it? I'm a beginner and at the end of what I can imagine...
Thanks in advance!
Adam
@Anonymous , see if you can split the columns into rows and that allows you better analysis
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |