Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |