Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Auto Scroll Bar Chart in power BI

Hello community

I have a bar graph that I want to scroll through the x-axis automatically and fence showing the values that make up the graph

 

Example: 

 

I want the scroll bar to move automatically from left to right and at the end of the variables return to the beginning

Need Help

3 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    If this chart is sort by the value of "Count of Cpersona", we can use the following workaround to meet your requirement:

     

    1. The following is our sample data model, we use the sum of value1 to sort the chart

     

     

    2. Then we can create a calculated table:

     

    PlayTable = GENERATESERIES(1,DISTINCTCOUNT('Fact Table'[Category]))

     

    3. use the following measue into the visual filter

     

    Axis Control = IF(RANKX(ALLSELECTED('Fact Table'),CALCULATE(SUM('Fact Table'[Value1])),,DESC,Dense)>=MIN('PlayTable'[Value]),1,-1)

     

     

     

    4. use the Play Axis in the Power BI Visuals MARKETPLACE, and set it to filter the main chart:

     

     

    5. Then we can make it scroll automatically

     


    Best regards,

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks v-lid-msft  but i have very large data set with direct query and the solution is very slow, but very very thanks.

      I think i can use d3.js for power bi, is more difficult but dont find another solution

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    6 years ago

    as far as i know I dont think this is possible with this visual, can you not adjust the size of your bars as that will be a better user experience than having to have it scrolled through.