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
Maisouiii
Regular Visitor

Filter of aggregation

Hello, 

 

Graph.PNG

 

As you can see on the graph below, I have data Prod elapsed time vs month and squad. Here data (hours) are cumulated in sum by month for each squad. I'd like to create a filter to show data as number, sum or average by month for each squad depending on the filter selected. To resume, I want to create a filter 'Show as' with option (number, Sum, Average), using the visual 'filter', if possible.

Thanhs in advance.

1 REPLY 1
vicky_
Super User
Super User

I think you're looking for field parameters - have a read of this article and see if it helps: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

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.