Forum Discussion

Himanshu's avatar
Himanshu
Frequent Visitor
8 years ago

Logic for custom buckets

   Hi Team, I am new to power bi, Can you help me to create these bucket as shown in screen shot.  We have Emp ID available in our tables but how to show count of EMP between 2016/2017 buckets?...
Himanshu's avatar
Himanshu
Frequent Visitor
8 years ago

Hi 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 :

 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

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