Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have some data visualized in Power Bi using R scripts (ggplot2 library). Field data (two variables, y as a function of x, black points) and two constant theoretical curves (red).
Data from several days
In order to compare the field data with the theoretical curves, I would like to obtain the maximum and minimum y values per x value per day. For example:
Day 1
Day 2
The objective is to obtain "envelope" curves, get rid of the rest of data and compare them in one visual respect to the theoretical curves.
Any ideas? How can I obtain the values in R script or in the query?
Thanks
@Jond ,
I think you can use dax instead, could you share the sample data and the output result?
Regards,
Jimmy Tao
I share some sample data (raw and sample report):
https://www.dropbox.com/sh/6lxcf9dj4v0yjoa/AAB8ClxYanQ70P5f73uwxbtga?dl=0
This should be the output result:
For each x value, the maximum and the minimum of y are stored and the rest of the data is discarded. The figure shows the maximum and the minimum values of y for a range of x. Each color is a different day.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |