Scrolling page with 10 charts based on Dynamic Rank

[Anonymous]

Hi All,

I'm trying to create a scrolling page which will have 10 charts vertically, and that update dynamically based on top sales.

I have an existing view where you can click on a slicer to update a single set of charts, however, the users have asked that this be a scrolling view with top 10 instead of having to click through each item.

The idea here is that there are 2000 products classified by geographies and I would like to rank them by largest to smallest sales and then show the largest product in the first chart, the second largest product in the second chart, etc. When you filter the geography this would also update to show only the top 10 products in that geography.

I've tried a few methods but haven't had much success and can't find anyone doing this before.

Hoping I can find some help here.

Thanks!

[v-diye-msft]

Hi @Anonymous 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!

[TomMartens]

Hey @Anonymous ,

creating a scolling page requires 2 steps:

1. adjust the height of the report page that fits your reporting needs, if you select the canvas you can adjust the page settings:
   
   
   
2. First Power BI visualizes the new page size that it fits to your screen size
   
   to make the page scrolling, adjust the viewing format
   

Hopefully this is what you are looking for.

Regars,

Tom

[Anonymous]

Tom,

Thank you very much for the explanation on how to make a scrolling page. I had actually already completed this part though, what I am stuck on is figuring out how to make charts that tie to a dynamic rank. meaning i have 10 charts which each represent the top 10 elements by sales volume, and when i filter for geography, this would also update to show the top 10 based on specific geography.

Hoping you can help, Thanks!

Martin

[TomMartens · Accepted solution]

Hey @Anonymous ,

here you find a pbix

https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/ESohY6JQfxBJtfX57iZJ8NkBGpoKoscHZBmkrHny2cbjDg?e=E7hnII

please look at the page "Rank Directed To Visual".

I use this DAX statement to create a rank:

Rank Color Name by Sales Amount (Sales) = 
RANKX(
    ALLSELECTED('DimProduct'[ColorName])
    , [Sales Amount (Sales)]
    ,
    , desc
    , Dense
) 

There is a larger table visual on the left side, this visual is just used for demonstration purpose, to show if the rank measure is working.

Then there are three matrix visuals on the right side, as you can see only the color with rank 1 is used in the top matrix visual. This is achieved by leveraging a visual level filter:

In my simple example directing color names to visuals is simple because I use the column that is rank inside the visual.

Hopefully, this provides some ideas to tackle your challenge.

Regards,

Tom