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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
VoltesDev
Helper IV
Helper IV

Table visual : text mask-ing

Hi everyone,

 

Probably the title is weird, but what I meant is, if lets say in my table I have a field Text which contain date, something like this : 

VoltesDev_0-1645156704417.png

Is there a trick that when we display in Table visual, we can display the "1900 - 01 -01" to blank or hyphen "-" ? but without any addition of measure ? like in the setting perhaps ? I would also trying not to change in Power Query since I have use the "1900 - 01 - 01" in many measures for a condition, so would be very glad if I can only do something with the table visual it self only.

 

VoltesDev_1-1645156879407.png

 

 

Thanks,

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@VoltesDev , You need to have new column in power query or dax , just at time of display you can not suppress

 

=

if [Date] = #date(1900,01,01) then null else [Date]

 

or in dax

if([Date] = Date(1900,01,01) , blank(), [Date])

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@VoltesDev , You need to have new column in power query or dax , just at time of display you can not suppress

 

=

if [Date] = #date(1900,01,01) then null else [Date]

 

or in dax

if([Date] = Date(1900,01,01) , blank(), [Date])

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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