Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello Powerbi Users,
I am trying to create temporary table based on my datamodel and then aggregate it at product level to find the right bucket. So far I am not successful in getting it down
DATA MODEL
Product | Category | Region | Profit | Sales |
AA | Fashion | USA | 31 | 173 |
AA | Fashion | Canada | 42 | 223 |
AA | Fashion | China | 32 | 294 |
AA | Fashion | Australia | 50 | 226 |
AA | Fashion | India | 33 | 195 |
BB | Fashion | USA | 13 | 100 |
BB | Fashion | Canada | 5 | 233 |
BB | Fashion | China | 2 | 500 |
BB | Fashion | Australia | 4 | 177 |
BB | Fashion | India | 28 | 100 |
CC | Fashion | USA | 24 | 118 |
CC | Fashion | Canada | 14 | 152 |
CC | Fashion | China | 20 | 220 |
CC | Fashion | Australia | 10 | 211 |
CC | Fashion | India | 29 | 168 |
DD | Fashion | USA | 11 | 207 |
DD | Fashion | Canada | 26 | 124 |
DD | Fashion | China | 30 | 183 |
DD | Fashion | Australia | 25 | 222 |
DD | Fashion | India | 20 | 267 |
My output should be something like this. My chart in powerbi should be updated based on filters.
Thanks
Solved! Go to Solution.
Hi @hbgv123,
Thank you for reaching out to Microsoft Fabric Community Forum.
@johnt75 Thank you for your quicke response.
I’ve attached the PBIX file with the data you provided. Please review it, and let me know if you have any questions or need further adjustments.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
Hi @hbgv123,
Thank you for reaching out to Microsoft Fabric Community Forum.
@johnt75 Thank you for your quicke response.
I’ve attached the PBIX file with the data you provided. Please review it, and let me know if you have any questions or need further adjustments.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
You need the dynamic segmentation pattern - https://www.daxpatterns.com/dynamic-segmentation/