Forum Discussion
Blank Values In Cumulative Chart
Is there any way I can make the cumulative values appear when there is no data in the cumulative chart? I have a chart that shows the cumulative values for all the days in the month. Also, I have a date table related to the main table (TAB_CONSOLIDADA_GERAL) which provides all the dates. I want the value of the previous day to be shown when there is no data.
My current measure is as follows:
Cumulative_Total =
VAR vDateContext = MAX(TAB_CONSOLIDADA_GERAL[DTA_INIC_MNB])
RETURN
CALCULATE(
SUM(TAB_CONSOLIDADA_GERAL[TOTAL]),
FILTER(
ALLSELECTED(TAB_CONSOLIDADA_GERAL),
TAB_CONSOLIDADA_GERAL[DTA_INIC_MNB] <= vDateContext
)
)
Anonymous , Please use date table in formula and axis
CALCULATE(SUM(TAB_CONSOLIDADA_GERAL[TOTAL]),FILTER(ALLSELECTED(date),date[date] <= max(date[date])))Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
3 Replies
Anonymous , Please use date table in formula and axis
CALCULATE(SUM(TAB_CONSOLIDADA_GERAL[TOTAL]),FILTER(ALLSELECTED(date),date[date] <= max(date[date])))Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.Hi, I have similar problem, when I use the above dax, I get all the totals.
Any idea how to resolve it sir?
