Forum Discussion
Bucketing values in a chart
Community SupportHi Anonymous
I can'd find any information about "bucket" from your post.
i create a test example, Is the "bucket" already in the table or not?
| bucket | date | same day |
| a | 1/1/2019 | TRUE |
| a | 1/2/2019 | TRUE |
| a | 1/3/2019 | TRUE |
| a | 1/4/2019 | TRUE |
| a | 1/5/2019 | TRUE |
| a | 1/6/2019 | TRUE |
| a | 2/1/2019 | TRUE |
| a | 2/2/2019 | TRUE |
| a | 2/3/2019 | TRUE |
| a | 2/4/2019 | TRUE |
| a | 2/5/2019 | TRUE |
| b | 1/1/2019 | TRUE |
| b | 2/1/2019 | TRUE |
| b | 2/2/2019 | TRUE |
Could you show an exmaple data to let me know the data structure?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Maggie.
I did not create buckets yet. What i did create is the dax function that is setting up a different target each month, based on certain criteria within the data. Any % can be set as a target here. I have applied conditional formating, based on this target. You can see the dax function setting bucket treshold above.
Below are table data example of relevant columns
Case Duration WeekStart Same Day People Survey Sample 0.004664352 26/11/2018 TRUE 7 1 4.855381944 26/11/2018 FALSE 6 1 5.062164352 19/11/2018 FALSE 3 1 0.010983796 26/11/2018 TRUE 10 1 0.816400463 26/11/2018 TRUE 7 1 0.026550926 19/11/2018 TRUE 10 1 3.949016204 19/11/2018 FALSE 10 1 0.051875 12/11/2018 TRUE 5 1 0.037731481 19/11/2018 TRUE 1 1 0.003865741 26/11/2018 TRUE 3 1 5.964594907 19/11/2018 FALSE 9 1 10.888125 26/11/2018 FALSE 1 1 1.852303241 12/11/2018 FALSE 4 1 2.027476852 12/11/2018 FALSE 5 1 13.97271991 19/11/2018 FALSE 9 1 2.138171296 19/11/2018 FALSE 9 1 4.952349537 19/11/2018 FALSE 3 1 4.817337963 19/11/2018 FALSE 5 1 4.053009259 19/11/2018 FALSE 4 1 12.0850463 19/11/2018 FALSE 2 1 2.011712963 19/11/2018 FALSE 6 1 3.06244213 19/11/2018 FALSE 3 1 38.98818287 19/11/2018 FALSE 9 1 4.677303241 26/11/2018 FALSE 8 1 36.0149537 26/11/2018 FALSE 6 1 2.237060185 26/11/2018 FALSE 8 1 0.97787037 26/11/2018 TRUE 2 1 3.849837963 26/11/2018 FALSE 1 1 1.060590278 26/11/2018 FALSE 1 1 2.92556713 26/11/2018 FALSE 8 1 10.57021991 19/11/2018 FALSE 3 1 6.830324074 19/11/2018 FALSE 2 1 4.23212963 19/11/2018 FALSE 4 1 7.894641204 19/11/2018 FALSE 3 1 7.861412037 19/11/2018 FALSE 9 1 Hope this makes it clearer
Filarap
- v-juanli-msft
Hi Anonymous
As tested, it seems impossible to achieve this requirements.
If you have to achieve this goal, please post another one to let more people see your problem.
Best Regards
Maggie