Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ashaikh
Helper III
Helper III

Trend Line in Power BI

Hello,

 

I want to have a trend line on the following visualization.

trend.png

This graph is based on following formula.

 

TICKET COUNT TREND = 
SUMMARIZE (
    vRCCLCOMBINED,
    vRCCLCOMBINED[WEEK START DATE AND END DATE],
    vRCCLCOMBINED[WEEK NUMBER],
vRCCLCOMBINED[QUARTER], "TICKET COUNT INCIDENTS", COUNTX ( FILTER ( vRCCLCOMBINED, vRCCLCOMBINED[DATA ORIGINATE] = 1 && vRCCLCOMBINED[START TIME].[Year] = MAX(vRCCLCOMBINED[START TIME].[Year])), vRCCLCOMBINED[TICKET ID] ), "TICKET COUNT WORKORDERS", COUNTX ( FILTER ( vRCCLCOMBINED, vRCCLCOMBINED[DATA ORIGINATE] = 2 ), vRCCLCOMBINED[TICKET ID] ) )

 

 Any help with how can I do it will be appreciated.

 

Thanks

Abdulquadir

1 ACCEPTED SOLUTION

@ashaikh

Just in case, I came across this thread which talks about creating trendlines with DAX. You could try writing your own measure and then decide whether you want to use the combined bar and line chart or the DIY method.

Regards,

 

Paul.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

11 REPLIES 11

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.