Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started
Hello!
So I have a really ambitious thing that I want to try to do in Power BI.
Based on the table here under:
Product | Price | Slicer 1 | Slicer 2 | Slicer 3 |
A | 10 | 1 | 1 | 1 |
B | 25 | 1 | 1 | 1 |
C | 30 | 1 | 1 | 1 |
D | 45 | 1 | 1 | 1 |
What I want to do is have a 3 Slicer (or three other visuals that I can Select) with my products and then multiply them and see the total Price of It.
For example:
Slicer 1 = Select Product A and B
SLicer 2 = Select Product A (I need Product A count it 2 times).
And when I Sum them, it give me a total of 45( (10 * 2) + (25)),
I will just need no more that 4 slicers for this, thats why I choose this type of Format of table.
Basically looks like and What-if Analysis, but in my understanding the What-If-Analysis works in the entire column, and is not customable for each row.
Thanks!
Thank You So much!
That was really a smart and elegant way of solving it!
But there is a little issue.. I Have hundreds of Products, and their names are always changing (Some products come in and other products sotck out), How could we figure it out then?
Thank you!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
146 | |
72 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |