Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
GeekAlfPro
Resolver II
Resolver II

How to display measure value even it's blank

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

 

1 ACCEPTED SOLUTION
jjudy
Helper I
Helper I

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.

 

Show Items with no data 

View solution in original post

2 REPLIES 2
GeekAlfPro
Resolver II
Resolver II

Thanks @jjudy 

 

that was it !

 

have a good day

jjudy
Helper I
Helper I

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.

 

Show Items with no data 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.