topic Re: How to get dynamic data in Desktop

How to get dynamic data

Anonymous — Thu, 07 Dec 2023 09:31:50 GMT

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?

versions	No. of Machines
22.3.1.41	40
22.3.2000.2105	26
20.3.4000.4080	10
22.10.5.14	5
22.12.0.48	5
21.3.3000.3116	5
21.3.5000.5107	5
22.3.1000.1054	4
22.4.1.62	3
20.5.0.18	3
20.6.0.60	2
22.03.1.16	1
22.10.0.21	1
22.12	1
19.7.0.24	1
19.9.0.28	1

Re: How to get dynamic data

khaledHabib90 — Thu, 07 Dec 2023 09:39:10 GMT

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 🙂

Re: How to get dynamic data

Anonymous — Thu, 07 Dec 2023 10:38:11 GMT

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

Re: How to get dynamic data

khaledHabib90 — Thu, 07 Dec 2023 10:49:02 GMT

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"

Re: How to get dynamic data

Bibiano_Geraldo — Thu, 07 Dec 2023 13:44:34 GMT

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

".",

"|"

)

),,

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

Re: How to get dynamic data

Anonymous — Mon, 11 Dec 2023 08:46:36 GMT

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?