Population pyramid Tornado chart with slicer for year - Power BI

Question

I tried to build a population pyramid chart with some customize Tornado chart and the pyramid has 5 periods 2016, 2021, 2026, 2031, 2036

Is there any possible way to have 2016 as the default view

Answer 1

Use the following measure

erp_lowest_year = 

VAR min_year = MINX(ALL(Sheet1),Sheet1[Year])

RETURN 
CALCULATE(
    SUM(Sheet1[ERP]),
    FILTER(
        ALLEXCEPT(Sheet1,Sheet1[LGA],Sheet1[Agegroup],Sheet1[Sex]),
        Sheet1[Year] = min_year
    )
)

erp_sum = SUM(Sheet1[ERP])

erp_final = 
SWITCH(
    SELECTEDVALUE(Sheet1[Year]),
    BLANK(), [erp_lowest_year],
    [erp_sum] 

) 

And in tornado configure as below:

You can register for this online Power BI training course by Intellipaat to learn Power BI.