The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.