Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm trying to create a prognosis of the future revenues with 3 different R12-measures.
All looks good. Except that it would be better if I could make the lines start where the previous line ends.
This is how the measures look like in a table. "Revenue R12" only has data till this month, Prognosis Total is based on some activities and previous data, using "ISBLANK" for the months that I don't want to show.
Preferably there would be a setting to connect the dots, but I guess there is non. So then I guess I need to add the last number from Revenue R12 to Total Prognosis for the one month before I have data now. How can I do this? My ISBLANK says: Show Totalt Prognosis when Revenue R12 is blank.
Thanks for the suggestion. Works quite okay, but not perfectly as I want it.
I think it would be better if I could find a way to have the line in the same colour as the next period, like in my picture. Any further suggestions to achieve that?
I would just take a simple approach rather then over complicating it.
Create a measure or a calculated column with all three of them added together. This will create one single long line from Date X -> Date Y
Then create a dax measure to seperate the total column out ->
User | Count |
---|---|
53 | |
35 | |
20 | |
16 | |
15 |
User | Count |
---|---|
94 | |
76 | |
36 | |
22 | |
18 |