BCI Calendar with data from Current Month Blank

[Anonymous]

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:

[Anonymous]

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]

Add +0 to the end of your count calculation.

[Anonymous]

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]

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]

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]

Thank you @Anonymous  & @amitchandak  I was able to set client count to 0 on the Card Visual. However, with the new measure my BCI calendar still shows as blank.

[Anonymous]

Hi @Anonymous ,

Which visualization you are using? It seems not the default visualization in Power BI, it is a custom visual?

Best Regards

Rena

[Anonymous]

Its the BCI/Beyondsoft Calendar visual. I got it from the appsource

[Anonymous]

Hi @Anonymous,

Thanks for providing the information. Could you please provide some sample data? The column "ClientID", "Date" and "RegisteredDate" are from one same table?

Best Regards

Rena

[Anonymous]

Hi @Anonymous All columns are from the same table. I was using the Date & count of Client ID.

Additionally, I added a filter on the page for Current Month(column) the formula which is above. And filter for selecting the organization I want the data for.

I do not have any clients this month so I want the calendar to be displayed as follows:

Currently, when adding a filter for the current month the calendar just disappears. This is how my page looks like:

[Anonymous]

Hi @Anonymous ，

You are using a custom visual, maybe you can contact Power BI Custom Visuals Support (alias:pbicvsupport@microsoft.com) to help you solve this problem.

Best Regards

Rena

[amitchandak]

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