cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

BciCalendar dont work for multipe count

Hello everyone,

 

I use this plug-in for visualization the calendar. I have a date field named "duplicate creatAt" with format date, another column named "id". 

I want to have the total of ID per date. But it does't work. I cant understand why this is "no Data". 

 

You can find more details in my printscreens. Thanks a lot!

批注 2020-07-08 122208 3.png批注 2020-07-08 122117 2.png批注 2020-07-08 122451 4.png

1 ACCEPTED SOLUTION

Accepted Solutions
Helper II
Helper II

Re: BciCalendar dont work for multipe count

I found solution,

 

Use datavalue( ) to  change createdAt data type. And then, all is correct. 

View solution in original post

5 REPLIES 5
Highlighted
Resolver II
Resolver II

Re: BciCalendar dont work for multipe count

Hi @erikzzy,

As a workaround, would it be possible to count the "duplicate creatAt" values instead of the ID's to see if that works?

 

If that's not feasible can you try this to see if there is a problem with the data (or the visual being used)

When you create a Matrix visual and add the columns

"duplicate creatAt"

then

"ID"

does the sum of the ID's show as expected in the matrix visual?

Cheers,

Richard

Highlighted
Community Support
Community Support

Re: BciCalendar dont work for multipe count

HI @erikzzy,

It seems like you are work with third party custom visuals and faced the aggregate calculation issue.
Since we not so clear for the backend calculate logics, I'd like to suggest you contact the visual author to report and confirm if any issue during these calculations.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted
Helper II
Helper II

Re: BciCalendar dont work for multipe count

Thanks Richard. But it doesn't work.

Highlighted
Resolver II
Resolver II

Re: BciCalendar dont work for multipe count

Hi @erikzzy,

As @v-shex-msft was suggesting it looks like there is an issue with the third party visual being used.

It would be best to contact the provider of the third party visual in this case.

Sorry I couldn't be of more help with this one.

Cheers,

Richard

Helper II
Helper II

Re: BciCalendar dont work for multipe count

I found solution,

 

Use datavalue( ) to  change createdAt data type. And then, all is correct. 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors