Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slicer value not Holding

Hi All,

 

I have a Report with a slicer value ( a, b, c, d, e). I have selected a slicer value (Ex: A) and pinned the KPI to the dashboard. 

 

Now when I click on the tile on the dashboard (Which is pinned by applying slicer value A) it takes me to the underlying report but it is not holding the slicer value (A). It is showing whatever the last used slicer (Ex: If someone last used that report with slicer C). It used to work earlier but suddenly it's not working anymore.

 

Please let me know if you need more information.

 

Thanks in Advance.

 

 

 

 

Need Help
  • GilbertQ's avatar
    GilbertQ
    6 years ago
    Hi there

    When you pin an item to a dashboard it remembers the filter when it was pinned to the dashboard.

    When you click on a dashboard tile, it will remember the last state you had in your report and not the state of the dashboard tile.

    The reason (I personally think) behind this is because the report keeps your last viewed state. And the dashboard keeps the state it was pinned as a tile.

    So the reports and dashboards are mutually exclusive (meaning that they do not keep each others settings once they are pinned (Dashboard) or viewed (Reports)

7 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi  Anonymous ,

     

    Yes,I agree with what is said by GilbertQ ,dashboard is just like a cover of your reports,what is shown on dashboard wont influence the actual reports,it is just a snapshoot of your reports,when you go to reports via dashboard,you will see the actual status of the reports.It may be same with what you see in dashboard,but may be different.All depend on the actual status of your reports.

    Hope this make sense.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you GilbertQ  & v-kelly-msft for the detailed explanation.

       

      But I am wondering, if this is the behavior of Dashboard and Report how come it worked for me earlier? It used to work as I expected, with the most recent update I am seeing this kind of behavior.

       

      Thanks,

      Abhilash

      • GilbertQ's avatar
        GilbertQ
        Super User
        6 years ago
        Hi there

        I have always seen the reports and dashboards behave in this manner. Not sure what has changed to be honest!
  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago

    Hi Anonymous 


    Can you make sure under the report settings you have configured the persistent filters have been applied per users.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      GilbertQ  I have tried with Persistent Filters and still no luck.

       

      To simplify:

      Slicer values: A, B, C

      Selected Slicer value A and pinned tile to the Dashboard A

      Selected Slicer value B and pinned tile to the Dashboard B

      Selected Slicer value C and pinned tile to the Dashboard C

       

      Now,

      IF I go to Dashboard A and click on the tile it takes me to the Report but Slicer value C is showing (Since it was last used by me to pin). What I am expecting is Slicer Value should be A.

       

      Thanks in Advance

       

       

       

      • GilbertQ's avatar
        GilbertQ
        Super User
        6 years ago
        Hi there

        When you pin an item to a dashboard it remembers the filter when it was pinned to the dashboard.

        When you click on a dashboard tile, it will remember the last state you had in your report and not the state of the dashboard tile.

        The reason (I personally think) behind this is because the report keeps your last viewed state. And the dashboard keeps the state it was pinned as a tile.

        So the reports and dashboards are mutually exclusive (meaning that they do not keep each others settings once they are pinned (Dashboard) or viewed (Reports)