Forum Discussion
Sales Bucket in Power BI
Thank you very much. I will try to use both and update you. Once again, thank you.
Community SupportHi SG25048519 ,
Please try create a calculate column in the 'Group By Bucket' table via
Sales Value =
CALCULATE (
SUM ( 'Group By Bucket'[Sales] ),
FILTER (
'Group By Bucket',
'Group By Bucket'[Parent Company]
= EARLIER ( 'Group By Bucket'[Parent Company] )
)
)
another column
Sales Bucket =
SWITCH (
TRUE (),
[Sales Value] >= 0
&& [Sales Value] <= 25000, "0-25000",
[Sales Value] > 25001
&& [Sales Value] <= 50000, "25001-50000",
[Sales Value] > 50001
&& [Sales Value] <= 100000, "50001-100000",
[Sales Value] > 100001
&& [Sales Value] <= 250000, "100001-250000",
[Sales Value] > 250001
&& [Sales Value] <= 500000, "250001-500000",
[Sales Value] > 500000, "500001+"
)
If it does not work, please share your pbix file without sensitive data.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your help.
The dashboard has monthly data from 2017 onwards, when I use this column measure, it takes up all the months since 2017, even though the page is filtered at page level. Also this is a column and not a measure .
Secondly the bucket query will not accept a column (above), it should be a measure. I tried but dont seem to work.
Not sure if I can share the file, as all the data is sensitive.
- v-chenwuz-msft
Hi SG25048519 ,
Replace sensitive information with false information. It's hard to figure out what the problem is without seeing your model and data.
Best Regards
Community Support Team _ chenwu zhu