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 one colum with some values like
scot/english
english/scot
english
scot
so i want to filter my data by putting all this values in one cluster "english"
if it some easy way to do this?) i can make some more column and fill it with custom values like if ... then...
but mb its more easy way?
replace data not good variant, couse i want to update info every month.
Solved! Go to Solution.
Hi @maybevlad,
In this scenario, could you go to check if the custom visual Attribute Slicer on Power BI Visual Gallery helps?
Regards
Hi @maybevlad,
Have you tried using SEARCH function in this scenario? The formula below to create a new calculate column for cluster is for your reference.
New Cluster = IF ( SEARCH ( "english", Table1[Column1], 1, 0 ) + SEARCH ( "scot", Table1[Column1], 1, 0 ) > 0, "English", "Others" )
Regards
Not so good) Couse i want to filter all info via 20+ claster and want to use for this "filter" vvisualisation, as i understand its impossible to do this using "search"
Hi @maybevlad,
In this scenario, could you go to check if the custom visual Attribute Slicer on Power BI Visual Gallery helps?
Regards
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |