Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

BCI Calendar with data from Current Month Blank

Hello,

 

I have used the BCI calendar to show the number of clients registering to a website each day. 

I also have a calculated field that calculates the current month as I want the data only from the latest month.

 

Today being the 1st day of the month(1st March), no data is available in my underlying table. And my calendar visual doesn't render at all! I would rather see a calendar with a label saying no data available than no visual at all in my report. Is there any way to do this?

 

Here is a screenshot of my report:

 
Need Help

12 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    You can do that but make sure take care of number formatting

     

    measure = if(isblank([measure]),"No date",[measure]&"")

     

    It will allow only one data type to use format to format the measure if need

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous,

    Could you please provide the formula for the calculated column or measure you applied for visuals (see below screenshot)? We can adjust their formulas so that it displays the appropriate information on the visuals even if no data is returned.

    Best Regards

    Rena

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      The Formula for the calculated column is 

      CurrentMonth = IF(AND(YEAR((Table1[RegisteredDate])=YEAR(TODAY())), MONTH(Table1[RegisteredDate])=MONTH(TODAY())),1,0)
       
      This is then added as a page filter to show all where CurrentMonth is 1
       
      I've not added any measures to the visual.
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous,

        According to the screenshot in your previous reply, your report contains two visual: one is a card, and the other seems to be a chart. Are the fields applied onto these two visuals come from the fields in the table directly? If you want to get the number of clients who visited the website within a certain date range, you can write one measure (for example:

        CountOfClients = if(ISBLANK(COUNT('Client Access'[ClientID])),0,COUNT('Client Access'[ClientID]))

        ) as suggested by amitchandak and apply it to your visuals. So that it will display meaningful number or text instead of blank value on the visual even if the original table has no data.

        Best Regards

        Rena

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Does anyone have thoughts on how to get the BCI Calendar to reflect the current month. I created mine in March 2020, and it still shows the March calendar. It'd be nice to see the current month. Thanks!

    • jstorm's avatar
      jstorm
      Icon for Resolver III rankResolver III
      6 years ago

      Add +0 to the end of your count calculation.