Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |