Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Play axis visualization

Hi PBI community,

 

The play axis visualisation by default displays the highest data point across the year range for each location. Is there a way to set the default so it displays the first year of a data set? In this way when a user opens the page of the report the first year is shown. Otherwise, with it is giving misleading results. 

 

I know the play axis can be set to automatically start playing, but that is not a feature I want to use. 

 

This is the default year display - it is displaying the top result for a range of thirty years, which is misleading. 

 

This is how I would like it to display, showing the first year of the dataset:

 

 

Cheers,

Brent

 

Need Help
Tips and Tricks

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , In the play axis visual, use a visual level filter and check the measure you used in the map is not blank and see if that can help

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi amitchandak

       

      Thanks for the suggestion. Unfortunately this doesn't work.

       

      thanks nonetheless!

      Brent.

       

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi Anonymous ,

     

    According to your description, you can create a measure to display some years you want to display, and then put it in the filter on this visual, or directly filter the fields in the play axis to the years you want to display. The reference is as follows:

    After you clict button.


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi v-henryk-mstf and amitchandak, 

       

      That doesn't appear to resolve what I am trying to achieve. Like you suggest, I think I need a measure that sets the play axis to start at year 2001 from my date dimension table:

       

      • ‘Dim date’[End date]

       

      Can you suggest such a measure? As a reminder, here is my original request for assistance:

       

      • The play axis visualisation by default displays the highest data point across the year range for each location. Is there a way to set the default so it displays the first year of a data set? In this way when a user opens the page of the report the first year is shown. Otherwise, by showing the highest values it is giving misleading results. 

       

      Cheers,

      Brent