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.
Hello,
I want to have a trend line on the following visualization.
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
Solved! Go to Solution.
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.
Proud to be a Super User!
Paul on Linkedin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |