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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.