Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!
Solved! Go to Solution.
Hey @Anonymous ,
here you find a pbix
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
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!
Hey @Anonymous ,
creating a scolling page requires 2 steps:
Hopefully this is what you are looking for.
Regars,
Tom
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
Hey @Anonymous ,
here you find a pbix
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |