Forum Discussion

Will_Smothers's avatar
Will_Smothers
New Member
1 year ago
Solved

Help With a Stacked Line Chart

We are a manufacturing company and we are working on ingesting data in PowerBI to help us drive efficiencies. Currently we are collecting the following data into an Excel spreadsheet: Date of produ...
Need Help
  • MFelix's avatar
    MFelix
    1 year ago

    Hi Will_Smothers ,

     

    Create the following two measures:

    Schedulle = HOUR(MAX('Table'[SCHED: RATE/PC]))+MINUTE(MAX('Table'[SCHED: RATE/PC]))/100

Actual = HOUR(MAX('Table'[ACT: RATE/PC:]))+MINUTE(MAX('Table'[ACT: RATE/PC:]))/100

    Add the dynamic format in the following way:

     

    """" & FORMAT(MAX('Table'[ACT: RATE/PC:]), "hh:mm") & """"

"""" & FORMAT(MAX('Table'[SCHED: RATE/PC]), "hh:mm:ss") & """"

     

    Now add it to the visual:

    Check PBIX file attach.

     

MFelix's avatar
MFelix
Super User
1 year ago

Hi Will_Smothers ,

 

Create the following two measures:

Schedulle = HOUR(MAX('Table'[SCHED: RATE/PC]))+MINUTE(MAX('Table'[SCHED: RATE/PC]))/100

Actual = HOUR(MAX('Table'[ACT: RATE/PC:]))+MINUTE(MAX('Table'[ACT: RATE/PC:]))/100

Add the dynamic format in the following way:

 

"""" & FORMAT(MAX('Table'[ACT: RATE/PC:]), "hh:mm") & """"

"""" & FORMAT(MAX('Table'[SCHED: RATE/PC]), "hh:mm:ss") & """"

 

Now add it to the visual:

Check PBIX file attach.