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 dear community,
In the Scatter chart, do you know how to add a constant value line based on a measure? 🙄
Thanks for your help
BR
Hi @Anonymous
Currently it is not supported to add a constant line based on a measure in a scatter chart. Other lines (Min/Max/Average/Median/Percentile lines) can only select measures already in X/Y axis fields. You may check if they can meet your needs.
There are some ideas about dynamic constant lines that you can vote for:
Microsoft Idea · Dynamic constant line for scattergraph (powerbi.com)
Microsoft Idea · Constant trend line as a measure (powerbi.com)
Microsoft Idea · Base constant line off of measure (powerbi.com)
Microsoft Idea · Add Dynamic reference lines to scatter plot (powerbi.com)
Regards,
Community Support Team _ Jing Zhang
@Anonymous
That is definately doable. When you create measure just use 'ALL' function to ignore the x axis filter context.
Please share more details or dummy data if above is not helpful.
@Anonymous , I doubt you are allowed to add a measure as a line. As of now the option in advance analytics are available with Min/Max/Average line
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane
Scatter by Akvelon has this functionality.
This should be added to the Power BI scatter
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |