Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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 |
Solved! Go to 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"
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?
1- Create a new column with the following code:
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 🙂
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"
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
69 | |
65 | |
54 |