Summarize timestamps per day in line chart

[AlbertPietens]

Hi all,

I have a realtime dataset (semantic model) with transactions with a timestamp, like 07-13-2024 06:23:33. I want to make a linechart that shows me the number of transactions per day. When I select a line chart it will show al the timestamps on de X-axis, so everytime it will be 1. Resulting in a flat chart that does not give any insight in volume per day. See image below.

Is it possible to summarize the number of transactions per day? Adding another table or data source is not possible because it requires met to switch to direct query in stead of the realtime data.

Help would be really appreciated.

[Anonymous]

Hi, @danextian 

thanks for your concern about this issue. 

Your answer is excellent! 

And I would like to share some additional solutions below.

Hi, @AlbertPietens 

According to your description, you want to Summarize timestamps per day in line chart? 

If I understand you correctly, then you can refer to my solution. 

After connecting to the data source in Desktop, You can use DAX formula to New Column: 

Date = DATEVALUE(FORMAT(Table1[Timestamps], "MM/DD/YYYY"))

Then use this column in the visuals: 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,
Fen Ling,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian]

Hi @AlbertPietens 

Does that realtime semantic model get stored in a data source Power Query can connect to? If so, you can parse the date from the timestamp and use that your chart isntead.

[AlbertPietens]

Hi @danextian, It does not. I tried a few things and it resulted in me deleting the data in the model. So for now I chose to store the data in a regular Power Query and that fixes the issue. It creates a new issue with refreshing the data because I would like to do that every 5 minutes.

[danextian · Accepted solution]

If you can push the streaming dataset to a sql database and connect to it via direct query,   you can set the reprot page to refresh every few minutes.