Forum Discussion

Sam7's avatar
Sam7
Icon for Advocate II rankAdvocate II
2 years ago

PBI Select Visual not filtering any results

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? 

 

 

 

Need Help

3 Replies

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion
    2 years ago

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

    • Sam7's avatar
      Sam7
      Icon for Advocate II rankAdvocate II
      2 years ago

      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.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.