Bar Chart - Change "Blank" Title of a single bar to "No Date"

[Anonymous]

Hi there, 

instead of changing my source data i'd like to use Power BI to automatically change any "Blanks" to show text. The Source data is currently formatted to Date within Excel and therefore any text written in there doesnt come through to Power BI. 

I have a Bar Chart below showing what is happening.  Is there a way to make Power BI show "No date" instead of Blank?

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

As @yakm said,  to add a calculated column or add a column to the power query and use the new column as the X-axis.

1). in power bi

_date = IF(ISBLANK([Date]),"No date",FORMAT([Date],"long date"))

2).  in power query

And sort by Date, the result like this:

Please refer to the attachment below for details. Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Fantastic - this is exactly what i needed thank you 🙂

[Anonymous]

you need to firstly check what is in the legend of the visual, then go to the table view and add new calculated column with if formula (this is for the case you have legend from your fact table)

if you have this legend from separate table the easiest way would be probably to change it to the fact table as i described 

[Anonymous]

Hey, thanks for the reply... very new to the program and have inherited the power bi document. are you able to elaborate at all for me please? (sorry!)

[Anonymous]

i think you can try creatin calculated column that replaces blank with "no date" or you can do it in power query

[Anonymous]

maybe i should include this?

i've tried to do an iferror show "No Date Given" but doesnt work...