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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
VoltesDev
Helper IV
Helper IV

How do you visualize a log table to identify record changes ?

Hi guys,

Need some advice when we have a table contain data log history, and we want to visualize from time to time what are the changes being made (and maybe by who), what is the best way to visualize it ?

 

I don’t have any data yet, but I think like a common log table contain several field in our original table, let say if it is Sales Orders table, the log table may contain field such as item id, prices, qty, delivery date, status, modify (entry) by. So time to time in one sales order the value of the fields may change. And in each changes, this table log will record this, so there will be as much line (row) as the data changed. I would like to build a report that visualize this.

 

Probably the purpose (for start) is to find which field changed very often or whose the person that keep changing data.

 

Appreciate for any idea.

 

Thanks

 

1 REPLY 1
v-yiruan-msft
Community Support
Community Support

Hi @VoltesDev ,

Please review the following links, hope they can help you achieve the requirements.

Best ways to visualise your data in Power BI

DAX:

Record Changes

yingyinr_0-1651202194218.jpeg

Track price changes

Power Query:

How to track changes in the table in Power Query

If the above ones can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

How to upload PBI in Community

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

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors