The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
@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
User | Count |
---|---|
80 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |