Forum Discussion
Line Chart Show empty dates as 0
Hi! I have a table (a Sharepoint list really) where i manually add each post from my company and I have the following columns: Topic (basic idea of the post) Content (long text area) Date (date ...
@jrnunsys , +0 to the extent you can do that. But this can show all dates.
Try a meausre like
0 entre rango
Medida = var _1= SUM(Opportunity[Opportunity count]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
devolución
CALCULATE(if(max('Calendar'[Fecha]) <_min || max('Calendario'[Fecha]) >_max , BLANK(), _1))
I've been looking for the answer to this same problem for quite some time, really glad I found this post, it doesn't solve it completely due to the data I use but it definatly gives me a better idea on how to approach it.
Thank you!