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.
A simplified version of data I'm working with for example purposes:
Identifier | Data1 | Stage | Completed? |
Active1 | 2 | 1 | |
Active1 | 4 | 2 | |
Active2 | 4 | 1 | |
Active2 | 3 | 2 | |
Active3 | 5 | 1 | |
Active3 | 4 | 2 | |
Completed1 | 6 | 1 | 4/15/2019 |
Completed1 | 7 | 2 | 4/15/2019 |
Completed2 | 4 | 1 | 4/12/2019 |
Completed2 | 2 | 2 | 4/12/2019 |
Completed3 | 8 | 1 | 3/28/2019 |
Completed3 | 6 | 2 | 3/28/2019 |
Completed4 | 8 | 1 | 2/15/2019 |
Completed4 | 2 | 2 | 2/15/2019 |
Stage would be along the X-Axis (so only 1 and 2 for this example). I would have 4 lines.
Active 1: 2 , 4
Active 2: 4 , 3
Active 3: 5 , 4
CompositeCompleted: 6.5 , 4.25 (average of all Completed for each stage)
Basically, I'm trying to plot all active data as individual lines, and then all completed data as one line. I have the data plotting correctly independent of each other. I have created 2 measures - one called Active and the other called Composite. Composite takes the avg(Data1) and filters where Completed? is not blank. Active looks where Completed? is blank. If I put Composite as a Value and do not include anything in my Legend - it graphs fine. If I put Active in my Values and include Identifier in the Legend, it plots all 3 lines. I don't know how to plot one composite line and also the 3 non-composite lines at the same time. I can't seem to figure it out. I really tried to simplify what I'm doing for help - but if you need more details please let me know and I can post some. But essentially I think the main issue is how do I have a legend of the different Identifiers and then a custom one called Composite (instead of completed1, completed2, etc.)
@djones - It will work if you create a separate measure for each Identifier. It doesn't seem ideal, but could be OK if there is a known, small number of identifiers.
Alternatively, you could layer two line charts on top of each other, but then the bottom one won't be interactive at all.
Cheers!
Nathan
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
89 | |
88 | |
77 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |