[CoE Starter Kit - Feature]: Requesting additional slicers and visualizations in the PBI reports

[DaveTheTeamsGuy]

Is your feature request related to a problem? Please describe.

More of an inconvenience than a problem - I add certain customizations to the PBI reports each time a new CoE version is released.

Describe the solution you'd like

Would it be possible to add the following items to the relevant reports?

• Connection tier slicers - Great for differentiating between apps and flows with standard and premium connectors. I add this to the App Usage, Apps, Cloud flows, App Connections. Basically any report that could benefit from a tier slicer. I also add an app connection tier and flow connection tier slicer to the Makers visualization.

• Unique App Launches clustered bar chart on the App Usage report - Good for seeing how many unique app launches per useful, helpful in determining licensing needs. I can provide details on how I created the visualization if you want to proceed.

• Standalone flows calculated column on the Makers report - Another good tool for determining licensing needs for standalone flow makers. I can provide details on how I created the visualization if you want to proceed.

Describe alternatives you've considered

I am currently creating my own visualizations for these needs.

Additional context?

No response

[Jenefer-Monroe]

Hello I'll see if I can add these for you!

[DaveTheTeamsGuy]

Great! Here's how I did it, if it helps:

Unique App Launches clustered bar chart on the App Usage report:
Clustered Bar Chart
Title: Unique App Launches
Y-Axis: 'Audit Log' [admin_userupn]
X-Axis: Count of 'Audit Log' [admin_appid]

Standalone flows calculated column on the Makers report
Calculated column titled "Standalone flows "in the Flow dataset
Sum of [Standalone flows]
Standalone flows = CALCULATE(
DISTINCTCOUNT(Flow[cr5d5_flowtrigger]),
NOT Flow[cr5d5_flowtrigger] IN {"Request : PowerApp", "Request : PowerAppV2"}
)

I assume I got the triggers right. There may be more.

[manuelap-msft]

All of those changes are incorporated for our September release, targeted to release next week.

[CoEStarterKitBot]

@DaveTheTeamsGuy This has been fixed in the latest release. Please install the latest version of the toolkit following the instructions for installing updates. Note that if you do not remove the unmanaged layers as described there you will not receive updates from us.