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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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