Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 dynamicall...
Need Help
  • khaledHabib90's avatar
    khaledHabib90
    2 years ago

    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"

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Super User
2 years ago

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