Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Trying to fill an accumulated stacked chart with values, months that have no values. Using the previous months accumulated values for the empty parts. Any suggestions?
I use this messure to produce the values from CRM/Dynamics 365:
Accumulated CRM = SUMX(FILTER(ALLSELECTED(OpportunitySet);OpportunitySet[EstimatedCloseDate] <=MAX(OpportunitySet[EstimatedCloseDate]));OpportunitySet[EstimatedValues])
In tha image below I would like to have september accumulated values for october (if empty) and so on.
Hi @Rflad,
Have you resolved your issue? If you have, please mark the helpful reply as answer, or welcome to share your solution. So that more people will find the workaround.
Best Regards,
Angelia
Hi @Rflad,
What do your resource data look like? Why there is "empty" months? I notice you use ALLSELECTED function, is there a slicer in your report? Could you please share more details for further analysis?
Please try the following formula based on your measure, use the new measure and check if it works fine.
New_Accumulated = IF ( ISBLANK ( OpportunitySet[Accumulated CRM] ), CALCULATE ( OpportunitySet[Accumulated CRM], FILTER ( OpportunitySet, OpportunitySet[EstimatedCloseDate] = DATE ( YEAR ( MAX ( OpportunitySet[EstimatedCloseDate] ) ), MONTH ( MAX ( OpportunitySet[EstimatedCloseDate] ) ) - 1, DAY ( MAX ( OpportunitySet[EstimatedCloseDate] ) ) ) ) ), OpportunitySet[Accumulated CRM] )
Best Regards,
Angelia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |