Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hey,
I am currently working on a data set of interval data with a corresponding date as shown below:
The are more parameter and values than shown and I need a visuel representation of the actual values (not average, max, sum etc.).
Are anyone aware of such an add-on to BI?, thanks
VarName | TimeString | VarValue |
Load extruder [%] - [Actual Value DB.load_extruder] | 03/05/2022 14:00 | 9913 |
Melt temperature in front of melt filter - [Actual Value DB.melt_temp_in_front_of_mf] | 03/05/2022 14:00 | 2628 |
Meltpressure in front of melt filter - [Actual Value DB.pressure_in_front_of_mf] | 03/05/2022 14:00 | 3184 |
Load extruder [%] - [Actual Value DB.load_extruder] | 03/05/2022 14:00 | 9799 |
Melt temperature in front of melt filter - [Actual Value DB.melt_temp_in_front_of_mf] | 03/05/2022 14:00 | 2623 |
Meltpressure in front of melt filter - [Actual Value DB.pressure_in_front_of_mf] | 03/05/2022 14:00 | 3216 |
Load extruder [%] - [Actual Value DB.load_extruder] | 03/05/2022 14:00 | 9340 |
Melt temperature in front of melt filter - [Actual Value DB.melt_temp_in_front_of_mf] | 03/05/2022 14:00 | 2623 |
Meltpressure in front of melt filter - [Actual Value DB.pressure_in_front_of_mf] | 03/05/2022 14:00 | 3120 |
Load extruder [%] - [Actual Value DB.load_extruder] | 03/05/2022 14:00 | 9307 |
Melt temperature in front of melt filter - [Actual Value DB.melt_temp_in_front_of_mf] | 03/05/2022 14:00 | 2623 |
Meltpressure in front of melt filter - [Actual Value DB.pressure_in_front_of_mf] | 03/05/2022 14:00 | 3088 |
Load extruder [%] - [Actual Value DB.load_extruder] | 03/05/2022 14:00 | 9536 |
Solved! Go to Solution.
Hi @gregers1972 ,
According to your statement, I think you want to show all data instead of summarizing the data like sum ,max or average in visual.
Here I suggest you to try Don't summarize function in value field in your visual.
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.
The datatable was not so easy to read properly, now a better version
VarName | TimeString | VarValue | |
Load extruder [%] - [Actual Value DB.load_extruder] | 03/05/2022 14:00 | 9913 | |
Melt temperature in front of melt filter - [Actual Value DB.melt_temp_in_front_of_mf] | 03/05/2022 14:00 | 2628 | |
Meltpressure in front of melt filter - [Actual Value DB.pressure_in_front_of_mf] | 03/05/2022 14:00 | 3184 | |
Load extruder [%] - [Actual Value DB.load_extruder] | 03/05/2022 14:00 | 9799 | |
Melt temperature in front of melt filter - [Actual Value DB.melt_temp_in_front_of_mf] | 03/05/2022 14:00 | 2623 | |
Meltpressure in front of melt filter - [Actual Value DB.pressure_in_front_of_mf] | 03/05/2022 14:00 | 3216 | |
Load extruder [%] - [Actual Value DB.load_extruder] | 03/05/2022 14:00 | 9340 | |
Melt temperature in front of melt filter - [Actual Value DB.melt_temp_in_front_of_mf] | 03/05/2022 14:00 | 2623 | |
Meltpressure in front of melt filter - [Actual Value DB.pressure_in_front_of_mf] | 03/05/2022 14:00 | 3120 | |
Load extruder [%] - [Actual Value DB.load_extruder] | 03/05/2022 14:00 | 9307 | |
Melt temperature in front of melt filter - [Actual Value DB.melt_temp_in_front_of_mf] | 03/05/2022 14:00 | 2623 | |
Meltpressure in front of melt filter - [Actual Value DB.pressure_in_front_of_mf] | 03/05/2022 14:00 | 3088 | |
Load extruder [%] - [Actual Value DB.load_extruder] | 03/05/2022 14:00 | 9536 | |
Melt temperature in front of melt filter - [Actual Value DB.melt_temp_in_front_of_mf] | 03/05/2022 14:00 | 2618 | |
Meltpressure in front of melt filter - [Actual Value DB.pressure_in_front_of_mf] | 03/05/2022 14:00 | 2880 | |
Load extruder [%] - [Actual Value DB.load_extruder] | 03/05/2022 14:00 | 9176 | |
Melt temperature in front of melt filter - [Actual Value DB.melt_temp_in_front_of_mf] | 03/05/2022 14:00 | 2614 | |
Meltpressure in front of melt filter - [Actual Value DB.pressure_in_front_of_mf] | 03/05/2022 14:00 | 2864 | |
Load extruder [%] - [Actual Value DB.load_extruder] | 03/05/2022 14:00 | 9225 |
Hi @gregers1972 ,
According to your statement, I think you want to show all data instead of summarizing the data like sum ,max or average in visual.
Here I suggest you to try Don't summarize function in value field in your visual.
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.
Thanks, I already did this however it only works in table format and not in line charts and cannot use the XY plot as I have date and time on the x-axis.
Anyhow, thanks for you valued input 🙂
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
61 | |
46 | |
45 |