Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I need assistance with a challenge in Power BI.
Can anyone suggest a solution? Thank you in advance for your help!
@powerbinovice12 You would need to adjust your measures in your line chart to accomplish this. You can use ALL in the 2 measures you don't want to change and then filter down to just the filters within the line chart visual that you want to keep. Alternatively you could potentially use REMOVEFILTERS/KEEPFILTERS to accomplish this. Sample data would help me be more specific to model this up.
Hi, thank you for your quick reply! I have attached some sample data if that will help. This is what the chart looks like and it is connected to a line chart that has the sales amount of past closed sales, future closed sales, and possible future sales over several months.
Data:
Item Name | Company Name | Revenue | Sell Rate | Date |
Cups | Plasticware | 1000000 | 50% | 1-Jan-22 |
Remote Control Car | Fisher Price | 233041 | 43% | 1-Jan-22 |
Blenders | HomeTech Innovations | 3824364 | 45% | 1-Jan-22 |
Tablets | Tech Oasis | 3329296 | 56% | 1-Jan-22 |
Makeup | Beauty Bliss | 1932774 | 39% | 1-Jan-22 |
Bats | Athletic Edge | 3031794 | 65% | 1-Jan-22 |
Gloves | Luxe Threads | 1700549 | 54% | 1-Jan-22 |
Staplers | Write Away | 1713253 | 90% | 1-Jan-22 |
Puzzels | Playful Wonders | 2627605 | 78% | 1-Jan-22 |
Cups | Plasticware | 3444762 | 67% | 1-Feb-22 |
Remote Control Car | Fisher Price | 3216086 | 53% | 1-Feb-22 |
Blenders | HomeTech Innovations | 1809216 | 56% | 1-Feb-22 |
Tablets | Tech Oasis | 2025553 | 77% | 1-Feb-22 |
Makeup | Beauty Bliss | 3693491 | 45% | 1-Feb-22 |
Bats | Athletic Edge | 1467846 | 54% | 1-Feb-22 |
Gloves | Luxe Threads | 1149243 | 34% | 1-Feb-22 |
Staplers | Write Away | 3645063 | 52% | 1-Feb-22 |
Puzzels | Playful Wonders | 1548139 | 34% | 1-Feb-22 |
Measure 1 ( past closed sales): = sum(total revenue)
Measure 2 (future closed sales): =sum(total revenue)
Measure 3 (possible future sales): *complex formula
*they are all in different tables. I apologize for the vagueness, this is a work project. If I can claryify more, please let me know and I will do my best
@powerbinovice12 Could you please paste that data as text so I can copy and paste into an Enter Data query? Also, can I get your measure formulas?
User | Count |
---|---|
102 | |
91 | |
85 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |