Forum Discussion
Logic for custom buckets
Hi Himanshu,
For the screenshot, you need to use Matrix visual to visualize data, Bucket 2017 in Row group, Bucket 2016 in column group and the count values as matrix values. You can go through this tutorial to learn matrix visual.
For your requirement, it would be better you can share some sample data of source table, so we can try to test how to model data.
Best Regards,
Qiuyun Yu
Hi v-qiuyu-msftQiuyun,
Thanks for reply.. I have attached an excel file.. We have to craete 2 bucket (for 2016/2017) and show the count of Emp between them.
https://www.dropbox.com/s/o6b429w5pagjmkj/Data_Sample.xlsx?dl=0
Hi Himanshu,
Can you clarify the logic to return the "<1","1-2" and ">2", and "count of Employee between 2016 and 2017 bucket" regarding your sample data?
Best Regards,
Qiuyun YuHi v-qiuyu-msft,
<1 : Salary less than 1000
1-2 : between 1000-2000
>2 : greater than 2000
I have to create 2 bucket
Bucket 2016 | Bucket 2017
<1 | <1
1-2 | 1-2
>2 | >2
Logic is :: If in 2016 bucket Emp salary is "<1" and in 2017 bucket Emp salary is ">2" then the count of Emp comes between highlighted box :
Logic is :: If in 2016 bucket Emp salary is "<1" and in 2017 bucket Emp salary is ">2" then the count of Emp comes between highlighted box :
Hi Himanshu,
You can go to Query Editor, filter table for 2016 and 2017 year separately then merge them based on Emp. Then create calculated columns in report to return <1,1-2,>2, use matrix to visualize data. For more information, please see attached pbix file.
Best Regards,
Qiuyun Yu