Kindly help with the below question.

[MyPowerbi2020]

I have shared the sample data set here : https://drive.google.com/drive/folders/1-NWrN_cJrqYVYuYPAeSxh9QqEUVMGXkf?usp=sharing.

Question:

1). First we need to show a pie chart that shows no. of performed. Example , if user chooses date filter to be from 12-01-2019 till 17-01-2019 , then 3 times performed count will be 2, 2 times performed count will be 1. 2) When user will click on the no.s it should show the Names who clicked twice / thrice in a table below the pie chart.

Please help.

Thanks.

[v-eqin-msft]

Hi @MyPowerbi2020 ,

Not very clear.

Could you explain to me the  logic of the first/two point?

Dose No. stand for the (count number of Performed based on each Name )-1?

What does "Click twice in a table" mean?

...

Best Regards,
Eyelyn Qin

[amitchandak]

@MyPowerbi2020 ,

I think you are looking to measure bucketing or binning

refer to my video : https://www.youtube.com/watch?v=CuczXPj0N-k

or

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization