Graph of different values as a function of time

[DataCube]

Hi,

I'm new to PowerBi.
I'm getting a list of fire extinguishers and their pressure.
fire extinguisher name / pressure value / date
Ext1                                        12               02/10/2018
Ext2                                        10               02/10/2018
Ext3                                        14               02/10/2018
Ext2                                        11               04/10/2018
Ext1                                        16               04/10/2018
Ext3                                        9                 04/10/2018

I would like to display a graph that shows the changes in pressures over time. But I can't find at all how to set up my graph.

[DataCube]

Hi,

I'm new to PowerBi.
I'm getting a list of fire extinguishers and their pressure.
fire extinguisher name / pressure value / date
Ext1                                        12               02/10/2018
Ext2                                        10               02/10/2018
Ext3                                        14               02/10/2018
Ext2                                        11               04/10/2018
Ext1                                        16               04/10/2018
Ext3                                        9                 04/10/2018

I would like to display a graph that shows the changes in pressures over time. But I can't find at all how to set up my graph.

[BobBI]

Hello,

See , i came up with this solution. you can tweak this solution to compare with average of last few data points etc..... this is just to give me an idea/direction to create something as per your requriement. Hope this helps.

Note : i am comparing current value with last data point ( last data point could be yesterday or average of last 2 days etc..).

i created a calculated Table taking fields from your example and create 3 measures

Current = today's presure value for each Ext*

Datapoint = All previous value . this is example it will give value for 2nd OCT as there is no other date exists yet.

variance = current -  Datapoint  ( you can also create a seperate mesaure to calculate variance)

TableVariance = ADDCOLUMNS(
                              SUMMARIZE(Ext,
                                        Ext[Prod] )
                  ,"Current",CALCULATE(SUM(Ext[presure]),'Date'[istoday]=0)
                  ,"Data Point",CALCULATE(SUM(Ext[presure]),'Date'[istoday]<0)
                   ,"Variance",  CALCULATE(SUM(Ext[presure]),'Date'[istoday]=0) - CALCULATE(SUM(Ext[presure]),'Date'[istoday]<0)
                 )

You also need one Date table. ( link this table with main data table ( Ext in this example)

Date                       istoday

01-OCT-18                 -1

02-OCT-18                 0  (today)

03-OCT-18                

04-OCT-18                

istoday =istoday = if('Date'[Date]=today(),0,
          if('Date'[Date]=today()-1,-1,

          if('Date'[Date]=TODAY()-2,-2,-2 )))

Cheers Bob

[PattemManohar]

@DataCube Is it something similar you ar looking for...

[DataCube]

I'm looking to make this kind of graph :

So I created a "curve graph".
I put: Axis=Created (date), Legend=Name (ext1, ext2,...), Values=Values (pressure).
But I just get a straight line....

I want to see the pressure fluctuation of each extinguisher over time.