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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
SushmaReddy
Helper I
Helper I

Blank in a slicer

Hi Team,
 I use the below DAX to get the default slicer selection as Max date 
Date =SWITCH(TRUE(),_Material[Pro Date]=MAX(_Material[Pro Date]),
"Latest Date",format(_Material[Pro Date],"mm-dd-yyyy")&"").
SushmaReddy_0-1648449885844.png

I am getting blank which the other visuals are getting affected.

Is there any way to get the date in date format instead of Latest Date?

 

Best Regards

Sushma

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@SushmaReddy , Blank can be there because there missing date in dimension. Means dates are there in fact not there in the dimension table. or the column have blank

 

refer

https://www.youtube.com/watch?v=23qemkDqMVY

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
SushmaReddy
Helper I
Helper I

Thank you amitchandak

amitchandak
Super User
Super User

@SushmaReddy , Blank can be there because there missing date in dimension. Means dates are there in fact not there in the dimension table. or the column have blank

 

refer

https://www.youtube.com/watch?v=23qemkDqMVY

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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