Filter by a measure - Basic Disconnected Table Method not applicable

[Antonio91]

Hi everybody,

I'm not an expert in Power BI. I've got a Line and Stacked Column Chart with some rainfall data.

X axis has been rearrenged in order to display in columns the monthly precipitation from October (e.g. October 2021) to September (e.g. September 2022), and to reach this outcome I've used groups. Meanwhile, lines represent the cumulative annual precipitation in each hydrological year ("Anno idrologico" in the slicer on the left). Now, acting on the slicer allows me to filter the columns of the chart, but not the lines, which are calculated measures.  I've tryed to study the disconnected table method but it doesn't work, given that I guess i cannot rely on dates (they're not displayed in a chronological order) or amount of rainfall (each year cumulative precipitation restarts from zero). Please, can anybody help me?

Here are the links to the .pbix and the .xlsx files:

https://1drv.ms/u/s!AmB1iIhLzXlGgfYyMp8AtTT64ge-kw?e=msDcGV

Any suggestion is appreciated

Thanks a lot in advance

[v-jialluo-msft · Accepted solution]

^{Hi @Antonio91 ,}

^{Depending on your description, your issue is that the line chart doesn't show content based on the choice of slicer, but instead shows all the data all the time.}

^{You can try to resolve this issue by modifying the measure. Please try:}

[Ca'Bortolani [mm]] per 2017] =

IF(2017 in VALUES('Precipit  cumulata giornaliera'[Anno Idrologico]),

CALCULATE(

    SUM('Precipit  cumulata giornaliera'[Ca'Bortolani [mm]]]),

    'Precipit  cumulata giornaliera'[Anno Idrologico] IN { 2017 }

))

 

^{Final output:}

^{If my understanding is wrong, please point it out.}

^{Best Regards,}

^{Gallen Luo}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[Antonio91]

It works perfectly, thanks a lot!