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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

how to dynamically group duplicated values in a column

Dear All, 

I have built a report with Dataverse audit logs table, showing the apps in PP environments and Dataverse for Teams environments shared with external users (guests). The dataverse table (audit logs) shows me the number of times the external user launched the app, such as Power App Launch 252602b-df6p-4a25-a4d7-159a66666 - 2023-07-31T06:36:28., so the data are shown multiple times (rows) in the report. 

 

Considering that all data in each column are dynamic, for instance I mean a new PP environment can be added in the report...

 

how can i aggregate the values in one line to make my report clearer?

 

thank you,

 

 

 

1 ACCEPTED SOLUTION
Daniel29195
Super User
Super User

@Anonymous 

 

can you provide a clear visual example of what you mean with dummy data, and what is the desired output you are looking for ? 

 

 

best regards,

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

please below dummy data to understand better my question:

thank you in advance for your help

 

 

App Environment Display NameApp Display NameApp launchedExternal User UPNApp TypeApp ID
Environment Aapp APower App Launch 22d3220m-222-4f16-a8b0-22222b22 - 2023-02-20T15:30:10peter.dupont@societe.comCanvas22d3220m-222-4f16-a8b0-22222b22
Environment Aapp APower App Launch 22d3220m-222-4f16-a8b0-22222b22 - 2023-02-20T15:30:10peter.dupont@societe.comCanvas22d3220m-222-4f16-a8b0-22222b22
Environment Aapp APower App Launch 22d3220m-222-4f16-a8b0-22222b22 - 2023-02-20T15:30:10peter.dupont@societe.comCanvas22d3220m-222-4f16-a8b0-22222b22
Environment Aapp APower App Launch 22d3220m-222-4f16-a8b0-22222b22 - 2023-02-20T15:30:10peter.dupont@societe.comCanvas22d3220m-222-4f16-a8b0-22222b22
Environment Aapp APower App Launch 22d3220m-222-4f16-a8b0-22222b22 - 2023-02-20T15:30:10peter.dupont@societe.comCanvas22d3220m-222-4f16-a8b0-22222b22

@Anonymous 

sorry for the late reply .

 

you mean like this ? 

Daniel29195_0-1706203900580.png

 

this is automatically generated by power bi visuals .

 

if this is not what you meant , maybe shareing the output you want to achieve could help better understand your problem . 

 

 

 

 

 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠

Anonymous
Not applicable

Daniel29195
Super User
Super User

@Anonymous 

 

can you provide a clear visual example of what you mean with dummy data, and what is the desired output you are looking for ? 

 

 

best regards,

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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