Forum Discussion

lovishsood1's avatar
lovishsood1
Resolver I
4 years ago
Solved

Show items with No Data not working with Format Function

Hello Everyone,

 

Problem: Not able to display "Show items with no Data" after changing the format of Month Name from "January" to "Jan".

Also, I tried creating a simple calculated column for changing the format of the Month. But still not able to get Blank Months.

I hope, You have understood my problem.

 

FYI ,

 

I need blank months but with MonthName in Short Form. Like above.

Need Help
Show and Tell
Tips and Tricks
  • lovishsood1's avatar
    lovishsood1
    4 years ago

    I resolved it by taking a separate Date Table and linking it with the Date column of the Table and then taking the Month from the Date table in the chart.

     

    Month = FORMAT('Calendar'[Date],"mmm") 
     
    This resolved my problem.

1 Reply

  • lovishsood1's avatar
    lovishsood1
    Resolver I
    4 years ago

    I resolved it by taking a separate Date Table and linking it with the Date column of the Table and then taking the Month from the Date table in the chart.

     

    Month = FORMAT('Calendar'[Date],"mmm") 
     
    This resolved my problem.