Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
84 | |
77 |