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.

     

Will_Smothers's avatar
Will_Smothers
New Member
1 year ago

THANK YOU!!! That is exactly what I needed!

 

What this post has shown me is that I need to really dig into writing DAX and start understanding it better! I struggled with this for two solid weeks and you fixed it with four lines of DAX!!

 

Thank you very Much Miguel!!!

  • MFelix's avatar
    MFelix
    Super User
    1 year ago

    Hi Will_Smothers ,

     

    The main question over here is the fact that visualizations don't play nice with time or date formats, so you need to transform them into numbers, in this case decimals, and them make a formatting of that result.