Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gregers1972
Frequent Visitor

Visualisation for interval datatypes (continous data) without modifications like average

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

 

VarNameTimeStringVarValue
Load extruder [%] - [Actual Value DB.load_extruder]03/05/2022 14:009913
Melt temperature in front of melt filter - [Actual Value DB.melt_temp_in_front_of_mf]03/05/2022 14:002628
Meltpressure in front of melt filter - [Actual Value DB.pressure_in_front_of_mf]03/05/2022 14:003184
Load extruder [%] - [Actual Value DB.load_extruder]03/05/2022 14:009799
Melt temperature in front of melt filter - [Actual Value DB.melt_temp_in_front_of_mf]03/05/2022 14:002623
Meltpressure in front of melt filter - [Actual Value DB.pressure_in_front_of_mf]03/05/2022 14:003216
Load extruder [%] - [Actual Value DB.load_extruder]03/05/2022 14:009340
Melt temperature in front of melt filter - [Actual Value DB.melt_temp_in_front_of_mf]03/05/2022 14:002623
Meltpressure in front of melt filter - [Actual Value DB.pressure_in_front_of_mf]03/05/2022 14:003120
Load extruder [%] - [Actual Value DB.load_extruder]03/05/2022 14:009307
Melt temperature in front of melt filter - [Actual Value DB.melt_temp_in_front_of_mf]03/05/2022 14:002623
Meltpressure in front of melt filter - [Actual Value DB.pressure_in_front_of_mf]03/05/2022 14:003088
Load extruder [%] - [Actual Value DB.load_extruder]03/05/2022 14:009536
1 ACCEPTED 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.

RicoZhou_0-1663567942857.png

 

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.

View solution in original post

3 REPLIES 3
gregers1972
Frequent Visitor

The datatable was not so easy to read properly, now a better version

VarNameTimeString 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.

RicoZhou_0-1663567942857.png

 

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 🙂

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.