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"

khaledHabib90's avatar
khaledHabib90
Resolver II
2 years ago

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's avatar
Anonymous
Not applicable
2 years ago

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

  • khaledHabib90's avatar
    khaledHabib90
    Resolver II
    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"