Forum Discussion

SabineOussi's avatar
SabineOussi
Skilled Sharer
6 years ago

Line Chart - Multiple numeric values on the same X point

Hello community!   I'm trying to achieve the below (in Excel) using Power BI. Where one date has multiple values. The aim is to show these values as separate numbers on a vertical line.   ...
Need Help
Tips and Tricks
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, SabineOussi 

 

Based on your description, I create data to reproduce your scenario..

Table:

 

If there is no column put in the 'Legend' to classify the vlaue for each date. It will calculated the sum aggregation value of the date.

 

When you add a column 'Category' as below and put it in 'Legend', here is the result.

 

 

Best Regards

Allan

 

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

SabineOussi's avatar
SabineOussi
Skilled Sharer
6 years ago

Thank you for your help.

 

The request is to have one continuous vertical line showing the length/duration of that datapoint.

Unfortunately, the solutions provided do not answer that.

 

Thanks,

Sabine O.

  • tex628's avatar
    tex628
    Community Champion
    6 years ago

    Another more simple solution that should work is converting the date to datetime and adding a few hours to the (10-06 / 135) This will result in the datapoints not being on the same value on the X-axis but the result should look quite similar to what you're looking for.