Hi All, I have a Number column from 1-20 but I am not able to group like 1-101-151-20 Please help.

Hi Kolumam,Try the following steps 1. Import your data set2. Create 2 more references of your data set3. Now you will have 3 copies of your data. 4. Filter the data sets as follows Filter your 1st data set such that you have data for those records where the number column will have values between 1 and 10,2nd data set will have data for those records where the number column will have values between 1 and 15,3rd data set will have data for those records where the number column will have values between 1 and 20, 5. Now create a static column.In the 1st data set, this column should have 1-10 as the dataIn the 2nd data set, this column should have 1-15 as the data In the 3rd data set, this column should have 1-20 as the data 6. Now append (union) these 3 queries7. After appending, you will have a single dataset will 3 sets of similar data8. Now use distinct values of this new column in your slicer selection.9. Your visual should have data from this new data set10. Changing Selections in the slicer will not filter the data for the groups But this has couple of limitations.1. Atleast one group in the slicer should always be selected. If not selected, the all the 3 copies will be displayed, which is not right2. This will result in multiple copies of the same data. But this will not affect performance as we are using reference In case of queries, let me know. Will try to help Hope this solves your requirement!!!

Grouping Values | Microsoft Fabric Community

Forum Discussion

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Community User Group Experience

Value display in row group and column group

User Group Leader Get Started Guide

FAQ on the Fabric User Groups