Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I really want to add Trend lines here using DAX , the same as using TREND function in Excel.
I'm very new to DAX, would you please let me know how to write DAX formula to add trend line?
Thank you.
@me418 , Thre dotted lines?
You can add a constant lines from the analytics pane.
In the newer version, you can use a measure in that
Hi,
Thank you for your suggestions.
After updating Power BI version, I can see Constant line under Analytics menu,
But it's constant line which is different what I need.
I need to add Trend line in this visual like in Excel.
Do you know if it's possible to add Trend line although the data format is not date?
Hi @me418
I think you want to create a trend line by dax like in excel.
Here I find a post with same requirement like yours, and I hope it could help you.
For reference: DAX to create a Trend line?
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |