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
lampard1987
Frequent Visitor

Visuals to display high amounts of data condensed

Hi,

 

Are there any visuals available that can display a high volume of data in a condensed format.

 

I have attached an example of something like what I am looking for.

 

Example visualsExample visuals

 

Thanks

1 ACCEPTED SOLUTION

Hi @lampard1987 ,

Please review the following thread and try the method in it. Hope it can help you.

Dealing with milliseconds in timestamps

If the millionseconds time does not show properly in visual. I would suggest you convert the time into precise millionseconds and then concatenate hour, minute, second and millionsecond in TEXT format. 

 

For more details about this workaround, you can refer to blog below:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Milliseconds-Duration/td-p/406698

 

In addtion, the actual time is still correct if you use them in your measure/calculate column, you can click table view and check the original data.


Best Regards

Community Support Team _ Rena
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
amitchandak
Super User
Super User

@lampard1987 , Power bi have continuous axis(shown above)  with Date/datetime and number

Axis_type.png

Hi @amitchandak ,

 

Thank you. The problem we have which I forgot to mention above is that a lot of the data we are trying to display needs to be differentiated by the date/time milleseconds.

Currently the data on the visual is grouped by date/time/second which is not accurate enough for what we need.

The raw data has the milleseconds in it however the viusal does not use this.

Hi @lampard1987 ,

Please review the following thread and try the method in it. Hope it can help you.

Dealing with milliseconds in timestamps

If the millionseconds time does not show properly in visual. I would suggest you convert the time into precise millionseconds and then concatenate hour, minute, second and millionsecond in TEXT format. 

 

For more details about this workaround, you can refer to blog below:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Milliseconds-Duration/td-p/406698

 

In addtion, the actual time is still correct if you use them in your measure/calculate column, you can click table view and check the original data.


Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.