Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
I would like get X Axis as last four quarters based on the selected quarter and year in filters, example when i select Q4 in 2018, i want to show Q3,Q2,Q1 in 2018 and Q4 in 2017 in charts, if i select Q2 in 2018, i want to show Q1 in 2018 and Q4,Q3,Q2 in 2017 in charts
Please advise how can i acheive above mentioned results through functions or any other method
thank you
Regards
Jayanthan
Solved! Go to Solution.
Hi @jayanthan
1.copy the "date" table to create a new table "date2"
don't connect this new table to other tables
add "year" and "quarter" from table "date2" to the slicer
2. create measures in the Sheet7
measure_value = SUM(Sheet7[value]) selected_Y = SELECTEDVALUE(Date2[Year]) selected_Q = SELECTEDVALUE(Date2[Quarter]) flag = IF ( MAX ( 'Date'[Year] ) = [selected_Y], IF ( MAX ( 'Date'[Quarter] ) < [selected_Q], 1 ), IF ( MAX ( 'Date'[Year] ) < [selected_Y], IF ( MAX ( 'Date'[Quarter] ) >= [selected_Q], 1 ) ) )
3. add [flag] in the Visual level filter
Best Regards
Maggie
Hi @jayanthan
1.copy the "date" table to create a new table "date2"
don't connect this new table to other tables
add "year" and "quarter" from table "date2" to the slicer
2. create measures in the Sheet7
measure_value = SUM(Sheet7[value]) selected_Y = SELECTEDVALUE(Date2[Year]) selected_Q = SELECTEDVALUE(Date2[Quarter]) flag = IF ( MAX ( 'Date'[Year] ) = [selected_Y], IF ( MAX ( 'Date'[Quarter] ) < [selected_Q], 1 ), IF ( MAX ( 'Date'[Year] ) < [selected_Y], IF ( MAX ( 'Date'[Quarter] ) >= [selected_Q], 1 ) ) )
3. add [flag] in the Visual level filter
Best Regards
Maggie
Hi jayanthan,
Try this:
Measure = CALCULATE(SUM(Table1[Value]),DATESINPERIOD('date'[Date],MAX('date'[Date]),-4,QUARTER))
Or follow this link:
Tell us if works for you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |