Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have a measure that calculate the first day of the month of my dataset for my vehicles
Date début données = CALCULATE(
IF(
ISBLANK(FIRSTDATE(daily_aggregate_final[Date])),
BLANK(),
FORMAT(FIRSTDATE(daily_aggregate_final[Date]), "d")
)
)
the trouble is if there no data at all for a specific vehicle, it is not displayed.
it works with the following code
Date début données Capte = CALCULATE(
IF(
ISBLANK(FIRSTDATE(daily_aggregate_final[Date])),
0,
FORMAT(FIRSTDATE(daily_aggregate_final[Date]), "d")
)
)
But i want to have blank instead of 0
how can i modify my measure to display all vehicles even if there no data.
Thanks
Solved! Go to Solution.
If it's only for a visual, you could right click on your vehicles in the visualization builder and select Show items with no data.
If it's only for a visual, you could right click on your vehicles in the visualization builder and select Show items with no data.