Forum Discussion
How to add fixed values to data from analysis services
Hello,
is it possible to add fixed values to data, that are from analysis services without adding or changing the model?
Fo example with an DAX measure?
I need the fixed data to be for year 2025. For the axis I'm using the date table, for the legend a dimension category and for the value a calculated DAX measure.
What I need is to add the last part in the visual - the 2025 data.
Data for 2025
| 2025 | |
| brown | 60 |
| blue | 70 |
| red | 45 |
| yellow | 50 |
Can this be done?
2 Replies
- amitchandak
Super User
ngutc , You can add a constant line using the Analytics pane, if that can solve the purpose
https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane
There is only a y-axis constant line available. I would need an x-axis, and even if it could be done. I just need a point value not a line. Also I need to add that valu to a future date value on the X-Axis
