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
poweruser55
Helper IV
Helper IV

Group measures in a slicer

I currently use a dynamic slicer for measures. But I would like to group the measure into one value in the slicer, for ex: Q1, Q2, Q3, Q4 is selected by 'Quarters' in the slicer. This is how I bring in the values on my table - 

Totals Columns = SWITCH([Column selection],"Jan FY22" ,[Jan FY22] & " "& [Jan FY22 % Δ PY] ,"Jan FY22 % Δ PY",[Jan FY22 % Δ PY]) It uses two measures and then I have a table listing those as 1 and 2 to make it a dynamic table.
1 REPLY 1
lbendlin
Super User
Super User

Explore the use of Field Parameters for measures.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.