Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 :
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.
Thanks,
Solved! Go to Solution.
@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])
@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])
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
91 | |
84 | |
76 | |
65 |
User | Count |
---|---|
145 | |
109 | |
109 | |
102 | |
96 |