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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors