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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

How to get dynamic data

Hi, i have some data like below. Now i want show latest version in every day. Here latest version is 22, in feature we will get more than 22 versions. By that time how to show the versions dynamically at page level filters?

versionsNo. of Machines
22.3.1.4140
22.3.2000.210526
20.3.4000.408010
22.10.5.145
22.12.0.485
21.3.3000.31165
21.3.5000.51075
22.3.1000.10544
22.4.1.623
20.5.0.183
20.6.0.602
22.03.1.161
22.10.0.211
22.121
19.7.0.241
19.9.0.281
1 ACCEPTED SOLUTION

oh yes the TOP N filter appears on visual filters

 

if you want only page level filter then add another custom column with below formula

MaxVersion = [version] = max('yourtable'[version])

 

this will return true if the version the latest

then add the new custom column to page level filters and filter for "true"

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Thank you for your above information. It's working fine. But,if i want top N functionality in this type of column, Because end user want to show latets 3 or 5 or something . In that case, how to we get top n functionality here?

Bibiano_Geraldo
Super User
Super User

1- Create a new column with the following code:

Rankx =
RANKX(
    'Sheet1', // Replace 'Sheet1' With your table name
    VALUE(
        PATHITEM(
            SUBSTITUTE(
                'Sheet1'[versions], // Replace 'Sheet1' With your table name
                ".",
                 "|"
            ),
            1
        )
    ),,
    DESC,
    Dense
)
2- In report view, drag your rankx column to "Filters on this page field" and make sure that the "filter type" is set to Advanced filtering, and then, in "Show items when the value" choose "is" as condition and set value to 1
ezgif-2-90f29c334a.gif


Is this post help you? Please consider to:
Accept as Solution!
Give a Kudo
Follow me on Linkedin: Bibiano_Geraldo_Mangue
khaledHabib90
Resolver II
Resolver II

so if I am understanding correctly, your latest version is the 2 numbers from the left in the "versions" column ?

If this is correct, create a new custom column with the below formula

version = Value(Left(versions,2))

this will give you a column that you can use in the page level filters, and you can then use TOPN filter type to choose top 1 value based on the version column

 

If my reply helped you to solve the problem, please accept it as the solution 🙂

Anonymous
Not applicable

After added the new column , i am not getting the TOP N filter option on above formula

oh yes the TOP N filter appears on visual filters

 

if you want only page level filter then add another custom column with below formula

MaxVersion = [version] = max('yourtable'[version])

 

this will return true if the version the latest

then add the new custom column to page level filters and filter for "true"

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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