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 d...
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.
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.
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?