Forum Discussion

MPrex's avatar
MPrex
Regular Visitor
1 year ago
Solved

Scatterchart with TimeSeries Data and Field

My dataset has 5 columns: Time, T1, T2 (temperatures), P1 and P2 (pressures). Time is a datatype Date/Time, while the others are decimals. I would like to plot T1, T2, P1 and P2 on y axis and Time ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi MPrex ,
    According to your error message, you can dynamically display the data on the x-axis by creating a MEASURE using the aggregate function.

    P1 Measure = SUM('Table'[P1])

    Final output

     

    Best regards,
    Albert He

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

MPrex's avatar
MPrex
Regular Visitor
1 year ago

Hi Anonymous 

Your solution works. 
Since in reality I have 100+ columns, I was wondering if I need to do this procedure "manually" for all of them. Is there a faster way?

Thanks!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi MPrex ,
Batch creation of MEASURES with the same structure is not possible in the current version of power bi desktop. The fastest way is to create it manually and it is also better to use it in parameters. You can create as many measures as you need, which will reduce the number of measures you need to create.

 

Best regards,
Albert He

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