Forum Discussion
rane19
Helper I
5 years agoHow to restrict only multi year based on single-selected slicer in bar chart axis ? Power BI
Sample Data : Date Type Family Type Sub Value 2018/01/01 Faimly_A A 377 2018/01/01 Faimly_A A 30 2018/01/01 Faimly_A B 470 2018/01/01 Faimly_B B 310 2018/01/01 Faimly_B C 11...
- 5 years ago
Ashish_Mathur
Super User
5 years agoHi,
I answered a similar question here - Flex a Pivot Table to show data for x months ended a certain user defined month.
Hope this helps
rane19
Helper I
5 years agoHi Ashish , appreciate for your reply and it is a very smart way to provide flexibility.
But my situation aims to keep the easiest and intuitive UI that "select only the current year you wnat to view" hence you see to chart have only 2 bar as ell . I need a measure to locking only 2 year in the chart .
Concept like :
# 2_years_period_measure =
VAR current_year = selectedvalue(Calendar[Date].[year])
RETURN
filter( current_year && current_year -1 )
hence use "2_years_period_measure" in chart graph Axis .
But i lack of knowledge to accomplish it .
- Ashish_Mathur5 years ago
Super User
- rane195 years ago
Helper I
Thankyou , amazing!
- Ashish_Mathur5 years ago
Super User
You are welcome.