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
dogt1225
Helper II
Helper II

Custom Period Slicer to default to specific date fields

I have a custom period filter for "Last 5 Quarters", "Last 5 Months", and "Last 5 Weeks". And a Parameter that dynamically filters the x axis based on 3 date fields, [Fiscal Year Quarter], [Fiscal Year Month], [Fiscal Year Week]


I am looking to have the functionality where,
 - If a user selects "Last 5 Quarters", then the Parameter is default to "Fiscal Year Quarter"
- If a user selects "Last 5 Months" , then Parameter is default to "Fiscal Year Month"... etc. 

Therefore I can remove the "Parameter" slicer from the report. Is there a way for this?

dogt1225_0-1680637232257.png

 

dogt1225_1-1680637265999.png

 

 

 

 

Parameter = {
    ("Fiscal Year Quarter", NAMEOF('Date'[Fiscal Year Quarter]), 0),
    ("Fiscal Year Month", NAMEOF('Date'[Fiscal Year Month]), 1),
    ("Fiscal Year Week", NAMEOF('Date'[Fiscal Year Week]), 2)
}
Period Filter = 

VAR _selectedperiod = SELECTEDVALUE('Last 5 Custom Period'[Period-Order])
    
VAR _last5qtr = 
    IF(
        CALCULATE(
            MAX('Date'[Date]),
            'Date'[Fiscal Year Quarter (Offset)] >= -4 && 'Date'[Fiscal Year Quarter (Offset)] <= 0
        ), 
        1, 
        0
    )

VAR _last5months = 
    IF(
        CALCULATE(
            MAX('Date'[Date]),
            'Date'[Fiscal Year Month (Offset)] >= -4 && 'Date'[Fiscal Year Month (Offset)] <= 0
        ), 
        1, 
        0
    )

VAR _last5wks = 
    IF(
        CALCULATE(
            MAX('Date'[Date]),
            'Date'[Fiscal Year Week (Offset)] >= -4 && 'Date'[Fiscal Year Week (Offset)] <= 0
        ), 
        1, 
        0
    )

RETURN
   INT(SWITCH(            
    _selectedperiod, 1, _last5qtr,
                     2, _last5months, 
                     3, _last5wks
   ))

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@dogt1225 , you can change the measure based on selected axis value. 

Just remember for trends using a date/period, date/period should come from an independent table

 

Changing measures based on the axis with Field Parameters in Power BI. Dynamic measures based on the axis/Dimension: https://youtu.be/7ikRAelDph0

Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

 

Power BI Abstract Thesis: Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@dogt1225 , you can change the measure based on selected axis value. 

Just remember for trends using a date/period, date/period should come from an independent table

 

Changing measures based on the axis with Field Parameters in Power BI. Dynamic measures based on the axis/Dimension: https://youtu.be/7ikRAelDph0

Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

 

Power BI Abstract Thesis: Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.