topic Re: Creating a basket of products in power BI in Developer

Creating a basket of products in power BI

Feerthoven — Mon, 19 Aug 2024 14:05:55 GMT

Hello Team,

I am working in Power Bi and my goal is to be able to pick a certain number of products (creating a basket) with different quantities each to see the total cost of the whole basket.

Would you guide me how to tackle that?

Thanks,

Fernando

Re: Creating a basket of products in power BI

lbendlin — Mon, 19 Aug 2024 17:21:57 GMT

Are your baskets predefined or are you thinking of creating dynamic baskets? (Hint: not supported in Power BI)

Re: Creating a basket of products in power BI

Feerthoven — Mon, 19 Aug 2024 21:56:04 GMT

Would be dynamic baskets based on a table (of products) already uploaded in Power Bi.

Should be able to do it in Power Bi or I need to combinde Power Apps as well?

Re: Creating a basket of products in power BI

lbendlin — Mon, 19 Aug 2024 21:59:29 GMT

A dynamic basket would be something like the Tableau LOD feature

Level of Detail Expressions - Tableau

As I mentioned this is not supported in Power BI. You need to know beforehand what buckets you want and how big they should be.

Re: Creating a basket of products in power BI

DaleT — Tue, 20 Aug 2024 00:55:05 GMT

Hi Fernando,

It depends. If the number of products is not large, it's possible. The products could be in a slicer in which you can make multi-selection. Each quantity is a slicer because you want to make it dynamic. Then the calculation is in a measure.

Dale

Re: Creating a basket of products in power BI

Feerthoven — Tue, 20 Aug 2024 10:45:10 GMT

Hi Dale,

How the calculation would be?

Could you provide an example please?

Regards,

Fernando

Re: Creating a basket of products in power BI

DaleT — Tue, 20 Aug 2024 18:29:43 GMT

Hi Fernando,

Please refer to the demo here https://drive.google.com/file/d/1aaUjyZHMoah6zXoXPXbYifBdIpCulsth/view?usp=sharing

I hope it helps.

Dale

Re: Creating a basket of products in power BI

Feerthoven — Tue, 20 Aug 2024 21:34:24 GMT

Hello Dale,

Looking at your example, it works perfectly for a predefined table but how should be done in case we keep adding products every once in a while (like merging new files monthly)?

Thanks again,

Fernando

Re: Creating a basket of products in power BI

lbendlin — Tue, 20 Aug 2024 23:16:40 GMT

As I mentioned this is not supported in Power BI. You need to know beforehand what buckets you want and how big they should be.

Re: Creating a basket of products in power BI

DaleT — Wed, 21 Aug 2024 00:34:33 GMT

Hi lbendlin,

Yes, this is only a workaround. Not perfect, but it works.

Hi Fernando,

Try out this new version, please. It's hard to make the slicer to be single-select, so there will be a warning when multi-select happens.

https://drive.google.com/file/d/11gW7atA2e1trMuGtcPDnIQ8dfm4w9x-J/view?usp=sharing

Dale

Re: Creating a basket of products in power BI

Anonymous — Fri, 23 Aug 2024 05:16:35 GMT

Can you tell me if your problem is solved? If yes, please accept DaleT 's and lbendlin 'sreply as solution.

If you have already solved it yourself,share your solution and accept it as a solution that will help other community members who have the same problem as you.

Best Regards,

Leroy Lu