set time values on linear diagramm to start from its value not from 00:00

[taher]

Hi All,

I've looked so much without success 😞

I am analysing a news table, which has these columns "news name "and  "importance" in a specisfic "date and time". For example :

news  name    importancedate

  XXXXXXX         5               2017-11-25 08:40

  XXXXXXX         5               2017-11-25 08:55

  XXXXXXX         7               2017-11-25 09:40

  XXXXXXX         17             2017-11-26 00:40

I need to create a linear diagramm wich shows the value of importance during the time.

I've splited the date column into date and time , because it didnt work to split it into day,month and time like this: 25.Nov 08:40.

The problem is: (look at the third and fourth line) the diagramm beginns to show the values from 00:00 to 23:59.

The X-axis should beginn in this case from 08:40 ( first date) till last date .

And also by importance, I can't choose 'dont summerize', I need the exact value no SUM or Average!!

I've inserted a photo for better understand 🙂

Thanks in advace!

[taher · Accepted solution]

Hi again 🙂

I did found a solution, which solve my Problem 🙂

First, split the Date/Time into Date column and Time column.

Second, add new column as Text and give the following formula:

Call Date for Hirarichy = CONCATENATE( CONCATENATE( CONCATENATE( CONCATENATE(CONCATENATE( CONCATENATE( DAY(articles[call_date]);".");FORMAT(articles[call_date];"MMMM"));" ");FORMAT(HOUR(articles[call_Time]);"00"));":");FORMAT(MINUTE(articles[call_Time]);"00"))

Now I have this format of Date/Time which I want for example: 5.December 18:10

Third, add this column as a x-axis 🙂

Now, when an article have two days values, the x-axis will beginn from the first available date NOT FROM THE EARLIEST and so on 🙂
hier ist a snapshot for more Details.

Regards,

Taher

[WolfBiber]

Hi,

first look to you DataTypes. It is important that PowerBi recognize the correct DataTypes for further operations

Is the Date Column of type DateTime ?

second: you need some kind of aggregation because PowerBi needs to now how to calculate if there are several values on one DataPoint in your chart. For Example showing importance with Date on X-achsis but more then one news Entry.

And the Chart is adjusting automaticly depending you DataEntries

  

Greetings

[taher]

Hi @WolfBiber,

thank you for your answer!

I've already done that and its working for the news, which have a one day data entry, but when the news have tow days or more data entries, starts the diagramm from the smallest date time!

In this photo you see a news which has tow days values starting from 18:30 on the 20th November and ends at 04:30 on the 21th November!

It does that unfortunately not right and starts from 00:00 because it doesnt know from which day to beginn!

So I need a new column which mergs a day and an hour (I dont know if that is possible ) , I think ,or have you another idea?

Thanks in advance!

Taher

[WolfBiber]

Hey,

maybe give us some example Data and your expected result as image, just to understand exactly your goal.

[taher]

Hallo @WolfBiber,

hier is a simple example:

 id               News                                       position                                    calling_date

 1            WC in Russia                                    1                                           2017.12.11  22:30

 2            WC in Russia                                    2                                           2017.12.11  23:30

 3            WC in Russia                                    2                                           2017.12.12  00:00

 4            WC in Russia                                    2                                           2017.12.12  01:30

it should showed like this:

But since I can't splite the date/time column into the format, which appears in the photo, I am trying to show just the time, which would beginn from 00:00 NOT from 22:30, unfortunetelly !