The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
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
))
Solved! Go to Solution.
@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
@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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
79 | |
71 | |
48 | |
41 |
User | Count |
---|---|
138 | |
108 | |
71 | |
64 | |
58 |