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.
I have data that exists in a single column, but the data is separated by semi colon, I could visualize the data, however, I don't want to show the number of records for the combination of values, I want to show the # of results for each value. I want to show the # of results per keyword, not the # of results per the combination of this keyword with others. My visualization looks like this:
Hi @Rach01,
is your problem solved?
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @Rach01
use Split Column By Delimiter...
... and Split into Rows
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
@mwegener Thanks for your reply. The issue here is it will make a separate row for each entry, which will duplicate other data in other columns. So if I have another tab in my report to get # of records for a specific value in another column, it will show wrong data.
How can we do this?
Hi,
Splitting data by rows is the only way to get your desired visual. To count unique values thereafter, use the DISTINCTCOUNT() function.
Hi @Rach01 ,
try to create a "filter" table and link it with a many-to-many relationship.
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |