PBI Select Visual not filtering any results

[Sam7]

Hello. 

I have a PBI Visiual Line stacked bar chart. I have two measures, one current year sales and one previous year sales. 

When I select the bar relating to current year, my other visuals (tables charts showing results by category) all change to show data related to the visual.  When I select the previous year sales my visuals all show as blank. 

Why is this, I know last year we had sales of £288 on 8th Jan, but when I select this line, I want my table data to change to show previous year. I used SAMEPERIODLASTYEAR to create my previous year data.

Please can I have some help? 

[v-rongtiep-msft]

Hi @VijayP , 

Thanks for your quick response.

Hi @Sam7 ,

Please have a try.

Create a measure.

Value in last 12 months = 
CALCULATE (
    SUMX('Table', 'Table'[Value]),
    DATESBETWEEN('Table'[Date], EDATE(TODAY(), -12), TODAY())
)

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[VijayP]

@Sam7  What are the fields added to other charts . Are you talking about Tooltip or the Visual . 

[Sam7]

You know when you select a visual, maybe a category column, this filters other charts based on this category - it's not a slicer or a tooltip. 

I want it so when my line part (the measure using same period previous year) is selected, my other visuals all filter to this, but this does not happen.