Pulse chart aggregates data between two events

[abruge]

Hello!

I am using pulse chart to plot river flow against time and feature the number of litter observed for each clean up. It was perfectly working two weeks ago but it is not anymore.

Here are some info about my data and what I think might be wrong:

 

River flow is plotted using columns "QJM_Wins" and "Date" in table "Débits".

 

Now, when I add events from table "Collecte", the river flow gets aggregated between two events.

I don't want this agregation but I didn't find a way to avoid it even when choosing the "don't sum up" option.

What's weird is that it was working this way 2 weeks ago.

I also found a difference compared with when it was working. My column "date" in table "Collecte" has no little icon confirming that it's a date in the right panel (as shown below over the red marks). However, in the top panel, I can read that this column is under a date format.

Thanks for all the help you could provide!

Antoine

[MFelix]

Hi @abruge ,

If you look at the images you are giving you have the field Date in two values on the second image HoroDateur and Titre d'événement on the first image the date is only on HoroDateur. Can you check if removing from the second field your chart work as expected.

Regarding the second part the icon means that the specific column was setup as a date column, right click the table and choose mark table as Date Table and select the date column should take back the icon.

[abruge]

Hello  @MFelix ,

Thank you for your quick answer.
Following your advice, I removed the field "Date" in the event section. The plot is as I want it (as in screenshot 2 I shared in my initial message) but the events (clean ups) are missing.

In fact, I have two columns named "Date". One is in table "Débits" and correspond to days from 01/01/2018 to now, day by day. I added this one in the horodator section. The second is in table "Collecte" and relates to the dates of clean ups. I put this one in the event section. I tried to replace it by clean up IDs but the problem is the same. Values of river flow between events still aggregate and I cannot select "don't sum up" when I clic right on "QJM" in the section "Values".

Regarding the date format, I cannot mark table "Collecte" as table date because the field date is not continious and some dates are present several times.

One solution to my problem would be to format my data differently as adviced when using Pulse chart, as below, but I will have to change completly the way I organise my data and I still don't understand why it was working this way two weeks ago.

Date	River Flow	Events	Event Size

What do you think @MFelix  or others? 🙂

Best,

Antoine

[MFelix]

Hi @abruge ,

Did you make the update for the new version of PBI? The changes can be from the updated version.

Is it possible to share a sample file? So I can make some tests?

[abruge]

Hello @MFelix ,

Here is a sample of my dataset. Please, let me know what you think!

I didn't manually update PowerBI but perhaps it did it on its own.

Best,

Antoine

[MFelix · Accepted solution]

Hi @abruge ,

To what I can test out  I always loose the the details because of the fact that the relationships are forcing the grouping of the information so only returning the values where the date is equal.

You want to have a chart that looks like your first image but with the highlights in the second image correct?

What I did was to had a measure as my events:

Events = 

Events = COUNT(Collecte[ID])

or 

Events = CONCATENATEX(Collecte;Collecte[ID])

First one just give a simple count second gives the concatenation of the ID for each date result is below and in PBIX attach.

[abruge]

Hello @MFelix ,

Thank you for your help and sorry for my slow reply.

It's exactly what I was looking for. Your solution works.

Thanks a lot for that!!! 

All the best,

Antoine