Forum Discussion
Power BI
Hi LoganFFS ,
Thank you for reaching out to the Microsoft Fabric community forum. Also, thanks to techies for the helpful response.
To achieve your goal of grouping client IDs into categories for slicer filtering, the best approach is to create a separate mapping table with two columns: ClientID and ClientGroup. You can then link this table to your main data using ClientID and use the ClientGroup field in your slicer. This approach is clean, easy to maintain, and scales well.
Depending on your situation, you might also consider these alternatives:
-
Creating a calculated column in your main table using DAX (like SWITCH or IF) to assign groups directly.
-
Using Power Query to add a custom grouping column before loading the data.
Both alternatives work well if your groupings are simpler or don’t change often.
I hope this gives you an idea, if you need any further assistance, feel free to reach out.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thankyou.
-
Hi LoganFFS ,
Thank you for reaching out to the Microsoft Fabric community forum. Also, thanks to techies for the helpful response.
To achieve your goal of grouping client IDs into categories for slicer filtering, the best approach is to create a separate mapping table with two columns: ClientID and ClientGroup. You can then link this table to your main data using ClientID and use the ClientGroup field in your slicer. This approach is clean, easy to maintain, and scales well.
Depending on your situation, you might also consider these alternatives:
-
Creating a calculated column in your main table using DAX (like SWITCH or IF) to assign groups directly.
-
Using Power Query to add a custom grouping column before loading the data.
Both alternatives work well if your groupings are simpler or don’t change often.
I hope this gives you an idea, if you need any further assistance, feel free to reach out.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thankyou.
Hi LoganFFS ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.