Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
ElliotP
Post Prodigy
Post Prodigy

Top 5 Page Title by number of pageviews with a date component

Good Evening,

 

I haven't been here in a little bit and it's good to see things are getting bigger and better than ever. I've been spending a lot of time in powerbi, learning dax, etc; lots of fun; now the question.

 

I'm trying to show the Top Five Page Titles of a Website (so a series of different text in a colum, similar groups like 'Home') weighted by the number of pageviews with a date component. Meaning; I'd like for a list of the Top Five Page Titles by Number of Pageviews while retaining the date feature as so I can use a slicer for the flexibility (date goes on the slicer).

Thing.png

I've tried using a TopN function, a Rank Function,Using the Filter, Parameters, trying something with Calculate(Sum(abc), Page Title)); but I can't seem to get it to come together. I know it can be done and I've done it for slightly different moderations of this, but I just can't think of how to do this right now.

 

Thoughts?

 

 

1 ACCEPTED SOLUTION
KGrice
Memorable Member
Memorable Member

Here's what I use to show the top x category in a visual:

 

PageViewsRank = RANKX(ALL(PageTitleTable[Page_Title]), [PageViewsMeasure], , , Dense)

 

I then drag that onto the visual level filter and set it to be less than or equal to 5, or however many you want to show. This should work with the month slicer as well, though that assumes your dates/months are in a separate table.

View solution in original post

3 REPLIES 3
KGrice
Memorable Member
Memorable Member

Here's what I use to show the top x category in a visual:

 

PageViewsRank = RANKX(ALL(PageTitleTable[Page_Title]), [PageViewsMeasure], , , Dense)

 

I then drag that onto the visual level filter and set it to be less than or equal to 5, or however many you want to show. This should work with the month slicer as well, though that assumes your dates/months are in a separate table.

Thank you so much.

 

I can't believe I didn't think of this; it worked perfectly. I can't say thank you enough.

You're welcome, @ElliotP!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.