Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.