Forum Discussion
Pulse chart aggregates data between two events
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.
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.
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
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?
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
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.