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.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
102 | |
77 | |
70 | |
48 | |
47 |
User | Count |
---|---|
158 | |
86 | |
80 | |
68 | |
66 |