Trend charts and Value Chart with filtered Month

[Betwin]

Hi All,

I have two charts on report page - one trend chart ( 13months ) and also column chart( by country on Axis X - and values) - but this chart is only for one month.  When i try to filtered trend chart by country from column chart it one dot appears for one month.

I know, i can disable filtering charts by interactions, but i would like to filter trend chart only by country, is it even doable ?

Thanks

[ryan_mayu]

@Betwin 

please share the sample data and expected output.

[Betwin]

Ryan, really sorry i cannot upload pbix on any filehosting page.

Share the screenshots, hope it would help. - i'm affraid it's not doable.

Thanks anyway.

[Betwin]

[v-kelly-msft]

Hi  @Betwin ,

Remove the "date" from your filters,and you will see:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Betwin]

Hi @v-kelly-msft , thnaks for replay

I cannot get rid off filters on both charts, as column charts should be always filtered on last month values( in this case June 20)

I found "around solution" -  duplicate data set - create relantionship beetwen country and use duplicated data to create trend chart.

I know that is not the best solution, but i do not have better now.

Thanks

[v-kelly-msft · Accepted solution]

Hi  @Betwin ,

Create a measure instead of using filters,put the filter criteria in the measure,such as below:

Measure = IF(MONTH(MAX('Table'[Date]))=1, CALCULATE(SUM('Table'[Visitor]),FILTER('Table',YEAR('Table'[Date])=YEAR(MAX('Table'[Date]))-1&&MONTH('Table'[Date])=12)), CALCULATE(SUM('Table'[Visitor]),FILTER('Table',YEAR('Table'[Date])=YEAR(MAX('Table'[Date]))&&MONTH('Table'[Date])=MONTH(MAX('Table'[Date]))-1)))

And you will see:

Pls note:in column chart,the values field should use the measure while in line chart use the fact table data.

Attached is the .pbix file if needed.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!